|
|
|
CONVERT function (ODBC compatible)
Syntax
{fn CONVERT (expression , data_type ) }
data_type::
SQL_BIGINT
| SQL_BINARY
| SQL_BIT
| SQL_CHAR
| SQL_DATE
| SQL_DECIMAL
| SQL_DOUBLE
| SQL_FLOAT
| SQL_INTEGER
| SQL_LONGVARBINARY
| SQL_LONGVARCHAR
| SQL_REAL
| SQL_SMALLINT
| SQL_TIME
| SQL_TIMESTAMP
| SQL_TINYINT
| SQL_VARBINARY
| SQL_VARCHAR
Description
The ODBC scalar function CONVERT 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 conversion. You must enclose the function with the ODBC escape clause {fn } to use ODBC-compliant syntax.
