Category: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}