Type conversion functions
This section describes the following type conversion functions:
| Function | Description |
|---|---|
| CAST | Casts the input expression to the specified type. |
| CHR | Returns the Unicode code point represented by value as a single character string |
| DECIMAL_TO_HEX | Converts a signed 64-bit integer to its hexadecimal string representation |
| HEX_TO_DECIMAL | Converts a hexadecimal string value to the corresponding signed 64-bit integer |
| TO_BIGINT | Convert any numeric value to a 64-bit signed integer. This will truncate any existing fractional part |
| TO_DOUBLE | Convert any numeric value to a double precision floating point IEEE-754 number |
| TO_STRING | Converts any value to a string representation |