|
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 AzureSynapseAnalytics supports all AzureSynapseAnalytics data types.
The following table describes how the AzureSynapseAnalytics data types are mapped to the ODBC data types.
| AzureSynapseAnalytics 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 |