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) |
Comments
Article is closed for comments.