Difference between revisions of "Literals"
| Line 2: | Line 2: | ||
=== Literals === | === Literals === | ||
| − | |||
| − | |||
{| width="1189" cellspacing="0" cellpadding="2" border="1" style="border-collapse:collapse; border:1px solid #010101" class="tableintopic" | {| width="1189" cellspacing="0" cellpadding="2" border="1" style="border-collapse:collapse; border:1px solid #010101" class="tableintopic" | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| width="204" bgcolor="#C0C0C0" style="border:1px solid #010101;" | | | width="204" bgcolor="#C0C0C0" style="border:1px solid #010101;" | | ||
| − | '''Type''' | + | '''Type''' |
| width="589" bgcolor="#C0C0C0" style="border:1px solid #010101;" | | | width="589" bgcolor="#C0C0C0" style="border:1px solid #010101;" | | ||
| − | '''Description''' | + | '''Description''' |
| width="396" bgcolor="#C0C0C0" style="border:1px solid #010101;" | | | width="396" bgcolor="#C0C0C0" style="border:1px solid #010101;" | | ||
| − | '''Examples''' | + | '''Examples''' |
|- align="left" valign="top" | |- align="left" valign="top" | ||
| width="204" style="border:1px solid #010101;" | | | width="204" style="border:1px solid #010101;" | | ||
| − | string | + | string |
| width="589" style="border:1px solid #010101;" | | | width="589" style="border:1px solid #010101;" | | ||
| − | Enclosed with ‘“’ and ‘“’ | + | Enclosed with ‘“’ and ‘“’ |
| − | Not contain ‘“’ or ‘/’ inside. | + | Not contain ‘“’ or ‘/’ inside. |
| − | New line character is not allowed | + | New line character is not allowed |
| width="396" style="border:1px solid #010101;" | | | width="396" style="border:1px solid #010101;" | | ||
| − | "an" | + | "an" |
|- align="left" valign="top" | |- align="left" valign="top" | ||
| width="204" style="border:1px solid #010101;" | | | width="204" style="border:1px solid #010101;" | | ||
| − | date | + | date |
| width="589" style="border:1px solid #010101;" | | | width="589" style="border:1px solid #010101;" | | ||
| − | Must be of the form: #yyyy-mm-dd hh:mm:ss# or #yyyy-mm-dd# used for where expression | + | 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] } | Array datetime: {yyyy, mm, dd, hh, mm, ss, [miliseconds], [week] } | ||
| − | Note: Timezone is available from 5.6. Read note below. | + | Note: Timezone is available from 5.6. Read note below. |
| width="396" style="border:1px solid #010101;" | | | width="396" style="border:1px solid #010101;" | | ||
| Line 46: | Line 44: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| width="204" style="border:1px solid #010101;" | | | width="204" style="border:1px solid #010101;" | | ||
| − | number | + | number |
| width="589" style="border:1px solid #010101;" | | | width="589" style="border:1px solid #010101;" | | ||
| − | Could be an integer, a floating point or decimal constant | + | Could be an integer, a floating point or decimal constant |
| width="396" style="border:1px solid #010101;" | | | width="396" style="border:1px solid #010101;" | | ||
| − | 123 | + | 123 |
| − | 1234E 1 | + | 1234E 1 |
| − | 123.4 | + | 123.4 |
|- align="left" valign="top" | |- align="left" valign="top" | ||
| width="204" style="border:1px solid #010101;" | | | width="204" style="border:1px solid #010101;" | | ||
| − | range | + | range |
| width="589" style="border:1px solid #010101;" | | | width="589" style="border:1px solid #010101;" | | ||
| − | Enclosed with [ and ] | + | Enclosed with [ and ] |
| width="396" style="border:1px solid #010101;" | | | width="396" style="border:1px solid #010101;" | | ||
| − | [1] | + | [1] |
| − | [1,2] | + | [1,2] |
| − | [1-2] | + | [1-2] |
| − | [1-2, 1] | + | [1-2, 1] |
| − | [1, 2, 3] | + | [1, 2, 3] |
|- align="left" valign="top" | |- align="left" valign="top" | ||
| width="204" style="border:1px solid #010101;" | | | width="204" style="border:1px solid #010101;" | | ||
| − | array | + | array |
| width="589" style="border:1px solid #010101;" | | | width="589" style="border:1px solid #010101;" | | ||
| − | Enclosed with { and } | + | Enclosed with { and } |
| width="396" style="border:1px solid #010101;" | | | width="396" style="border:1px solid #010101;" | | ||
| − | {1, 2, 3} | + | {1, 2, 3} |
|} | |} | ||
| + | |||
| + | Note: Timezone for datetime (V5.6) | ||
| + | |||
| + | Array datetime: {yyyy, mm, dd, hh, mm, ss, [miliseconds], [week] , [timezone]} | ||
[[Category:HelpBooks]] | [[Category:HelpBooks]] | ||
Revision as of 09:31, 20 January 2012
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]}
