Date and Time Improvements (ODBC)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

SQL Server 2008 (10.0.x) introduced new date and time data types. This section describes how these new types are exposed as extensions in SQL Server Native Client. For an overview of SQL Server 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).

In This Section

Data Type Support for ODBC Date and Time Improvements
Provides information about ODBC types that support SQL Server date and time data types.

Metadata (ODBC)
Describes information returned in the implementation parameter descriptor (IPD) and implementation row descriptor (IRD) fields, as well as column metadata returned by SQLColumns and SQLProcedureColumns. Also describes data type metadata returned by SQLGetTypeInfo.

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 SQL Server, and when a client compiled with an older version of SQL Server 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.

See Also

SQL Server Native Client (ODBC)