More actions
No edit summary |
No edit summary |
||
| 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;" | #2006-04-11 10:14:20# <br> | |||
|- 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} | ||
|} | |} | ||
| Line 90: | Line 86: | ||
<br> Note: Timezone for datetime (V5.6) | <br> Note: Timezone for datetime (V5.6) | ||
Array datetime: {yyyy, mm, dd, hh, mm, ss, [miliseconds], [week] , [timezone]} | Array datetime: {yyyy, mm, dd, hh, mm, ss, [miliseconds], [week] , [timezone]} | ||
[[Category:Data_Types_Literals_and_Variables]] | [[Category:Data_Types_Literals_and_Variables]] | ||
Latest revision as of 03:44, 9 February 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. |
#2006-04-11 10:14:20# |
|
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]}
Pages in category "Literals"
This category contains only the following page.