Date and Time Improvements in OLE DB

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

Download OLE DB driver

SQL Server 2008 (10.0.x) introduces new date and time data types. This section describes how these new types are exposed as extensions in OLE DB Driver for SQL Server. For an overview of the OLE DB Driver for SQL Server support for the new date and time data types, see Date and Time Improvements. For a sample, see Use Enhanced Date and Time Features (OLE DB).

For more general information about date and time data types, see datetime (Transact-SQL).

In this section

Data Type Support for OLE DB Date and Time Improvements
Provides information about OLE DB (OLE DB Driver for SQL Server) types that support SQL Server date and time data types.

Metadata (OLE DB)
Contains information about the DBBINDING structure, ICommandWithParameters::GetParameterInfo, ICommandWithParameters::SetParameterInfo, IColumnsRowset::GetColumnsRowset, and IColumnsInfo::GetColumnInfo. Also provides information about updates to OLE DB schema rowsets.

Bindings and Conversions (OLE DB)
Describes the rules for conversion between server and client for both existing and new date types.

Bulk Copy Changes for Enhanced Date and Time Types (OLE DB)
Describes date/time enhancements to support bulk copy operations.

OLE DB API Support for Date and Time Enhancements
Describes the OLE DB APIs that support enhanced date/time features.

Comparability for IRowsetFind
Describes date/time types and IRowsetFind.

See also

OLE DB Driver for SQL Server Programming