|
Supported Data Types - ODBC Driver for SQL Azure |
|
|
|
Supported Data Types - ODBC Driver for SQL Azure |
|
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 |