Datatypes – Zoola

The following simple datatypes may be declared as constants, used in expressions, and returned as values:

Simple Type	Description	Example of Constant
boolean	Expressions such as comparison operators return boolean values, but true and false constants are undefined and cannot be used.	none
integer	Whole numbers.	123 or -123
decimal	Floating point numbers. Decimal separators must be periods (.); other separators such as commas (,) are not supported.	123.45 or -123.45
string	Character strings entered with single quotes ('); double quotes (") are not supported.	'hello world'
date	ANSI standard date.	d'2009-03-31' or Date('2009-03-31')
timestamp	ANSI standard date and time.	ts'2009-03-31 23:59:59' or TimeStamp('2009-03-31 23:59:59')

The following composite datatypes may be declared as constants and used with the in set or in range operator. The values in these composite types are not necessarily constant, they could be determined by field values:

Composite Type	Description	Example
set	Contains any number of any simple type above.	(1, 2, 3)('apples','oranges')
range	Inclusive range applicable to numbers and dates, including fields that are number or date types.	(0:12) or (0.0:12.34)(d'2009-01- 01':d'2009-12-31')(limit_ min:limit_max)