Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## CONVERT (ODBC compatible)

> 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 ) }

> #### Note

> - Braces are part of the actual syntax:

> Syntax
>     SQL_BINARY  |  SQL_BIT    |  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

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095