MySQL HeatWave User Guide
The following operations are supported with the
CAST() function.
CAST() from and to all the
MySQL HeatWave supported numeric, temporal, string and text data
types. See Section 4.2.1, “Supported Data Types for MySQL HeatWave”.
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.
See Section 11.2.1.4, “Functions and Operator Limitations”.
Learn how to perform the following tasks: