ODBC Driver for Azure Synapse Analytics

Supported Data Types - ODBC Driver for Azure Synapse Analytics

Data Type Mapping

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

© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback