AllTypes
The AllTypes table function returns a fixed 10 row result set containing data examples for the various data types supported in xSQL. AllTypes is a utility function available for use in testing activities and to learn about xSQL’s data types (particularly helpful to understand the differences between the date and time related ones).
Syntax
AllTypes() |
Return Type
Table
Details
The AllTypes function returns a table with a columns and rows for each supported data type. The column name indicates the data type of the returned value.
The result set returned by the function contains the following columns:
| Column Name | Data Type | Description |
|---|---|---|
| string1 | string | A number stored as a string. |
| byte1 | byte | A byte value. |
| short1 | short | A short value. |
| integer1 | integer | An integer value. |
| long1 | long | A long value. |
| float1 | float | A float value. |
| double1 | double | A double value. |
| decimal1 | decimal | A decimal value. |
| decimal2 | decimal | Another decimal value with a bigger scale. |
| number_string1 | string | A decimal stored as a string. |
| datetime_string1 | string | A date_time stored as a string. |
| date1 | date | A date value. |
| time1 | time | A time value. |
| date_time1 | date_time | A date_time value. |
| offset_time1 | offset_time | An offset_time value. |
| offset_date_time1 | offset_date_time | An offset_date_time value. |
| zoned_date_time1 | zoned_date_time | A zoned_date_time value. |
| offset_date_time2 | offset_date_time | Another offset_date_time value. |
| zoned_date_time_europe1 | zoned_date_time | Another zoned_date_time example. |
| boolean1 | boolean | A boolean value. |
Examples
select * from AllTypes();
