| title | Date and Time Improvements (ODBC) | ||
|---|---|---|---|
| description | Date and Time Improvements (ODBC) | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.date | 03/14/2017 | ||
| ms.service | sql | ||
| ms.subservice | native-client | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
[!INCLUDEsql2008-md] introduced new date and time data types. This section describes how these new types are exposed as extensions in [!INCLUDEssNoVersion] Native Client. For an overview of [!INCLUDEssNoVersion] Native Client support for the new date and time data types, see Date and Time Improvements. For a sample demonstrating ODBC date/time support, see Use Date and Time Types.
For more general information about date and time data types, see datetime (Transact-SQL).
Data Type Support for ODBC Date and Time Improvements
Provides information about ODBC types that support [!INCLUDEssNoVersion] date and time data types.
datetime Data Type Conversions (ODBC)
Describes how to convert between datetime and datetimeoffset values.
sql_variant Support for Date and Time Types
Describes SQL_VARIANT function support for enhanced date and time functionality.
Bulk Copy Changes for Enhanced Date and Time Types (OLE DB and ODBC)
Describes date/time enhancements to support bulk copy operations.
Enhanced Date and Time Type Behavior with Previous SQL Server Versions (ODBC)
Describes the expected behavior when a client application using enhanced date and time features communicates with an older version of [!INCLUDEssNoVersion], and when a client compiled with an older version of [!INCLUDEssNoVersion] Native Client sends commands to a server that supports enhanced date and time features.
ODBC API Support for Enhanced Date and Time Features
Lists the ODBC functions that support enhanced date and time functionality.