Skip to content

Data Type Conversion Functions (ODBC Scalar Functions)

ODBC defines one explicit data type conversion function, CONVERT. Its syntax is:

CONVERT(value_exp, data_type)

The function returns value_exp converted to data_type, where data_type is one of the following keywords:

  • SQL_BIGINT
  • SQL_BINARY
  • SQL_BIT
  • SQL_CHAR
  • SQL_DECIMAL
  • SQL_DOUBLE
  • SQL_FLOAT
  • SQL_INTEGER
  • SQL_INTERVAL_MONTH
  • SQL_INTERVAL_YEAR
  • SQL_INTERVAL_YEAR_TO_MONTH
  • SQL_INTERVAL_DAY
  • SQL_INTERVAL_HOUR
  • SQL_INTERVAL_MINUTE
  • SQL_INTERVAL_SECOND
  • SQL_INTERVAL_DAY_TO_HOUR
  • SQL_INTERVAL_DAY_TO_MINUTE
  • SQL_INTERVAL_DAY_TO_SECOND
  • SQL_INTERVAL_HOUR_TO_MINUTE
  • SQL_INTERVAL_HOUR_TO_SECOND
  • SQL_INTERVAL_MINUTE_TO_SECOND
  • SQL_LONGVARBINARY
  • SQL_LONGVARCHAR
  • SQL_NUMERIC
  • SQL_REAL
  • SQL_SMALLINT
  • SQL_TYPE_DATE
  • SQL_TYPE_TIME
  • SQL_TYPE_TIMESTAMP
  • SQL_TINYINT
  • SQL_VARBINARY
  • SQL_VARCHAR
  • SQL_WCHAR
  • SQL_WLONGVARCHAR
  • SQL_WVARCHAR

See Also