ODBC Driver for SQL Azure

Supported Data Types - ODBC Driver for SQL Azure

Data Type Mapping

The Devart ODBC Driver for SQL Azure supports all SQL Azure data types.

The following table describes how the SQL Azure data types are mapped to the ODBC 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-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback