|
ODBC Driver for Azure Synapse Analytics Supported Data Types - ODBC Driver for Azure Synapse Analytics |
|
|
|
ODBC Driver for Azure Synapse Analytics Supported Data Types - ODBC Driver for Azure Synapse Analytics |
|
The Devart ODBC Driver for Azure Synapse Analytics supports all Azure Synapse Analytics data types.
The following table describes how the Azure Synapse Analytics data types are mapped to the ODBC data types.
| Azure Synapse Analytics 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 |