Converts an expression to another data type. The first argument is the expression to be converted. The second argument is the target data type.
The length option for the data_type argument specifies the length for conversions to CHAR and VARCHAR data types. If omitted, the default is 1 byte.
If the expression evaluates to NULL, the result of the function is null. Specifying NULL with the CAST function is useful for set operations, such as UNION, that require two tables to have the same structure. CAST NULL allows you to specify a column of the correct data type, so a table with a similar structure to another, but with fewer columns, can be in a union operation with the other table.
The CAST function provides a data‑type‑conversion mechanism compatible with the SQL standard.
Use the CONVERT function, enclosed in the ODBC escape clause { fn }, to specify ODBC‑compliant syntax for data type conversion. See for more information.
