The data type directly supported by a compiler is called a primitive data type.
Name | Description | Example |
bool | TRUE/FALSE | FALSE |
int, integer | An 8-byte signed integer Value range: -9,223,372,036,854,775,808 - 9,223,372,036,854,775,807 | 100000 |
string | A UTF-8-encoded string with a character length in the range of 1 - 2,147,483,647 | 'xyz' |
float | An 8-byte floating point | CAST(0.456 AS FLOAT) |
decimal, numeric | A decimal value with a maximum precision of 38 decimal places and in the range of $-2^{31}$ - $2^{31}-1$ | 123.456 |
timestamp | A timestamp represents a certain moment and can be expressed with any precision. A timestamp in text format follows the W3C specification but needs to end with "T" (unless recorded in days). When a fractional second is used, it should be accurate to at least one decimal place (with no upper limit on the number of decimal places). The offset of local time can be expressed by the offset expressed by hours and minutes when compared to UTC, or "Z" can be used to express the offset of local time from UTC. The time offset does not need to be displayed when only the date is recorded. | CAST('2007-04-05T14:30Z' AS TIMESTAMP) |
Apakah halaman ini membantu?