Literals
Literals
|
Type |
Description |
Examples |
|
string |
Enclosed with ‘“’ and ‘“’ Not contain ‘“’ or ‘/’ inside. New line character is not allowed |
"an" |
|
date |
Must be of the form: #yyyy-mm-dd hh:mm:ss# or #yyyy-mm-dd# used for where expression Array datetime: {yyyy, mm, dd, hh, mm, ss, [miliseconds], [week] } Note: Timezone is available from 5.6. Read note below. |
|
|
number |
Could be an integer, a floating point or decimal constant |
123 1234E 1 123.4 |
|
range |
Enclosed with [ and ] |
[1] [1,2] [1-2] [1-2, 1] [1, 2, 3] |
|
array |
Enclosed with { and } |
{1, 2, 3} |
Note: Timezone for datetime (V5.6)
Array datetime: {yyyy, mm, dd, hh, mm, ss, [miliseconds], [week] , [timezone]}
