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:

SQL_BINARY |  SQL_CHAR  |  SQL_DATE  |  SQL_DECIMAL  
  |  SQL_DOUBLE  | SQL_FLOAT  |  SQL_INTEGER  |  SQL_REAL
  |  SQL_SMALLINT  |  SQL_TIME  |  SQL_TIMESTAMP  |  SQL_TINYINT  
  | SQL_VARBINARY  | SQL_VARCHAR 

Compatibility

ODBC compatible