Difference between revisions of "Literals"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
Line 1: Line 1:
[[Category:HelpBooks]]
+


+
 
 +
=== Literals  ===
 +
 
 +
 
 +
 
 +
{| width="1189" cellspacing="0" cellpadding="2" border="1" style="border-collapse:collapse; border:1px solid #010101" class="tableintopic"
 +
|- align="left" valign="top"
 +
| width="204" bgcolor="#C0C0C0" style="border:1px solid #010101;" |
 +
'''Type'''
 +
 
 +
| width="589" bgcolor="#C0C0C0" style="border:1px solid #010101;" |
 +
'''Description'''
 +
 
 +
| width="396" bgcolor="#C0C0C0" style="border:1px solid #010101;" |
 +
'''Examples'''
 +
 
 +
|- align="left" valign="top"
 +
| width="204" style="border:1px solid #010101;" |
 +
string
 +
 
 +
| width="589" style="border:1px solid #010101;" |
 +
Enclosed with ‘“’ and ‘“’
 +
 
 +
Not contain ‘“’ or ‘/’ inside.
 +
 
 +
New line character is not allowed
 +
 
 +
| width="396" style="border:1px solid #010101;" |
 +
"an"
 +
 
 +
|- align="left" valign="top"
 +
| width="204" style="border:1px solid #010101;" |
 +
date
 +
 
 +
| 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
  
===Literals===
+
Array datetime: {yyyy, mm, dd, hh, mm, ss, [miliseconds], [week] }  
[miliseconds], [week] }
 
  
 
Note: Timezone is available from 5.6. Read note below.
 
Note: Timezone is available from 5.6. Read note below.
| style="border: 1px solid #010101" width="396" |
+
 
<nowiki>#2006-04-11 10:14:20#</nowiki>
+
| width="396" style="border:1px solid #010101;" |  
 +
#2006-04-11 10:14:20#
 +
 
 
|- align="left" valign="top"
 
|- align="left" valign="top"
| style="border: 1px solid #010101" width="204" |
+
| width="204" style="border:1px solid #010101;" |  
 
number
 
number
| style="border: 1px solid #010101" width="589" |
+
 
 +
| 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
| style="border: 1px solid #010101" width="396" |
+
 
 +
| width="396" style="border:1px solid #010101;" |  
 
123
 
123
  
Line 19: Line 57:
  
 
123.4
 
123.4
 +
 
|- align="left" valign="top"
 
|- align="left" valign="top"
| style="border: 1px solid #010101" width="204" |
+
| width="204" style="border:1px solid #010101;" |  
 
range
 
range
| style="border: 1px solid #010101" width="589" |
+
 
 +
| width="589" style="border:1px solid #010101;" |  
 
Enclosed with [ and ]
 
Enclosed with [ and ]
| style="border: 1px solid #010101" width="396" |
+
 
 +
| width="396" style="border:1px solid #010101;" |  
 
[1]
 
[1]
  
Line 34: Line 75:
  
 
[1, 2, 3]
 
[1, 2, 3]
 +
 
|- align="left" valign="top"
 
|- align="left" valign="top"
| style="border: 1px solid #010101" width="204" |
+
| width="204" style="border:1px solid #010101;" |  
 
array
 
array
| style="border: 1px solid #010101" width="589" |
+
 
 +
| width="589" style="border:1px solid #010101;" |  
 
Enclosed with { and }
 
Enclosed with { and }
| style="border: 1px solid #010101" width="396" |
+
 
 +
| 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]]
__NOTOC__
 
<!-- imported from file: 237.htm-->
 

Revision as of 11:17, 4 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.

  1. 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}