Type Conversion

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

Function

Description

Casts the input expression to the specified type.

Returns the Unicode code point represented by value as a single character string

Converts a signed 64-bit integer to its hexadecimal string representation

Converts a hexadecimal string value to the corresponding signed 64-bit integer

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