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 |