2.12.3 Cast Functions and Operators

The following operations are supported with the CAST() function.

• CAST() to DECIMAL.

• CAST() to YEAR.

• CAST() of VARLEN DATE, DATETIME, TIME, and YEAR column values to DOUBLE.

• CAST() of string column values to temporal types such as DATE, DATETIME, TIME, and YEAR.

• CAST() of TIME, DATETIME, TIMESTAMP, and DATE values to REAL, TIME, DATETIME, DATE, and YEAR.

• CAST() of values from DATETIME, TIMESTAMP, DATE, and TIME types to DOUBLE.

• CAST() of temporal types to VARCHAR.

• CAST() of DECIMAL and INTEGER types to DECIMAL. For example:

  mysql> CAST(c1 AS DECIMAL(5,2))

• CAST() of INTEGER values to SIGNED and UNSIGNED.

• 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.

• CAST() of FLOAT and DOUBLE values to DECIMAL.

See Section 2.16.3, “Functions and Operator Limitations”.