- style
YOU ARE CURRENTLY ACCESSING AN OUTDATED VERSION OF THE ZOOLA HELP DOCUMENTATION
Go to https://help.zoola.io for up-to-date documentation, videos, walkthroughs, and case studies.
Datatypes
- Zaqir Virani (Unlicensed)
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 ('); | 'hello world' |
date | ANSI standard date. | d'2009-03-31' or |
timestamp | ANSI standard date and time. | ts'2009-03-31 23:59:59' or |
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- |
Copyright © Lambda Zoola™