Sybase CEP expressions can include literals of various datatypes.
|
Datatype |
Examples |
|---|---|
|
Boolean |
TRUE, FALSE |
|
Integer |
1, -4455, 1234567899999L (long integer) |
|
Float |
1.2345, -999.999, 543.21e+3 (exponential format) |
|
String |
'Jane', "Dell Computers", "" (the empty string) |
|
Timestamp |
TIMESTAMP '2003-11-30 15:04' |
|
Interval |
INTERVAL '3 days 02:30', 3 days 2 hours 30 minutes |
|
Null |
NULL |
String literals may be enclosed in either single quotes or double quotes. Timestamp literals always consist of the word TIMESTAMP followed by a quoted string which represents the date and optionally the time for the timestamp. Interval literals can be in either a quoted form preceded by the word INTERVAL or in a segmented form without quotes, specifying the DAYS, HOURS, MINUTES and SECONDS for the interval. The null literal represents the absence of a value and is always just the word NULL.
For a complete explanation of literals used with CCL, please see the Sybase CEP CCL Reference.