skip to main content
Supported 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:
*Binary
*Character string
*Date
*Floating point
*Integer
*Numeric
*Time
*Timestamp
The following table describes the literal format for supported SQL data types.
Table 11. Literal Syntax Examples
SQL Type
Literal Syntax
Example
BIGINT
n
where:
n is any valid integer value in the range of the INTEGER data type.
12 or -34 or 0
BOOLEAN
Min Value: 0
Max Value: 1
0
1
DATE
'yyyy-mm-dd'
'2010-05-21'
DATETIME
'yyyy-mm-dd hh:mm:ss.SSSSSS'
'2010-05-21 18:33:05.025'
DECIMAL
n.f
where:
n is the integral part.
f is the fractional part.
0.25
3.1415
-7.48
DOUBLE
n.fEx
where:
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
INTEGER
n
where:
n is a valid integer value in the range of the INTEGER data type
12 or -34 or 0
LONGVARBINARY
'hex_value'
'000482ff'
LONGVARCHAR
'value'
'This is a string literal'
TIME
'hh:mm:ss'
'18:33:05'
VARCHAR
'value'
'This is a string literal'
* Character String Literals
* Integer Literals
* Numeric Literals
* Binary Literals
* Date/Time Literals