Type conversions functions

This section describes the following type conversions functions:

  • 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_DOUBLE: Convert any numeric value to a Double precision floating point IEEE-754 number.

  • TO_LONG: Convert any numeric value to a 64-bit signed integer. This will truncate any existing fractional part.

  • TO_STRING: Converts any value to a string representation.

Last updated