The following operations are supported with the CAST() function.
CAST()
CAST() from and to all the HeatWave supported numeric, temporal, string and text data types. See Section 2.10, “Supported Data Types”.
CAST() of ENUM columns to CHAR, DECIMAL, FLOAT, and to SIGNED and UNSIGNED numeric values. CAST() operates on the ENUM index rather than the ENUM values.
ENUM
CHAR
DECIMAL
FLOAT
SIGNED
UNSIGNED
See Section 2.18.3, “Functions and Operator Limitations”.