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 |