Converts an expression to another data type. The first argument is the expression to be converted. The second argument is the target data type.
If the expression evaluates to NULL, the result of the function is NULL.
The ODBC CONVERT function provides ODBC‑compliant syntax for data type conversions. You must enclose the function with the ODBC escape clause { fn } to use ODBC-compliant syntax.
Syntax
{ fn CONVERT ( expression , data_type ) }
Notes
Braces are part of the actual syntax. The following data types are used:
