ODBC Driver for SQL Azure

Supported Data Types

ODBC Driver for SQL Azure supports all the SQL Azure data types.

The complete list of SQL Azure data types is available in the SQL Azure documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to SQL Azure data types.

SQL Azure Data Types ODBC Data Types
Datetime SQL_TYPE_TIMESTAMP SQL_TIMESTAMP
Smalldatetime SQL_TYPE_TIMESTAMP SQL_TIMESTAMP
Date SQL_TYPE_DATE SQL_DATE
Time SQL_SS_TIME2
Datetime2 SQL_TYPE_TIMESTAMP SQL_TIMESTAMP

DatetimeOFFSET

SQL_SS_TIMESTAMPOFFSET

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback