SQL Statements and Extensions for the Salesforce Driver : SQL Expressions : Literals

Literals
Literals are fixed data values. For example, in the expression PRICE * 1.05, the value 1.05 is a constant. Literals are classified into types, including the following:
The following table describes the literal format for supported SQL data types.
n is any valid integer value in the range of the INTEGER data type
yyyy-mm-dd
yyyy-mm-dd hh:mm:ss.SSSSSS'
0.25 3.1415 -7.48
n.fEx
n is the integral part
f is the fractional part
x is the exponent
1.2E0 or 2.5E40 or -3.45E2 or 5.67E-4
where n is a valid integer value in the range of the INTEGER data type
12 or -34 or 0
hex_value
value
hh:mm:ss
value
Character String Literals
Integer Literals
Numeric Literals
Binary Literals
Date/Time Literals

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.