Progress
SQL-92
Guide and Reference


CONVERT Function (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.

data_type

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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095