ODBC Driver for SQL Server

Supported Data Types

ODBC Driver for SQL Server supports all the SQL Server data types.

The complete list of SQL Server data types is available in the SQL Server documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to SQL Server data types.

SQL Server 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-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback