OLE DB API Support for Date and Time Enhancements

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

Download OLE DB driver

The following OLE DB APIs support enhanced date/time features.

Function	Description
IAccessor::CreateAccessor	A flag is added in the DBBINDING structure to enable applications to discriminate between datetime, datetime2, and smalldatetime values. For more information, see Parameter and Rowset Metadata.
IBCPSession::BCPColFmt	For more information, see Bulk Copy Changes for Enhanced Date and Time Types (OLE DB).
ICommandWithParameters::GetParameterInfo	For more information, see Parameter and Rowset Metadata.
ICommandWithParameters::SetParameterinfo	For more information, see Parameter and Rowset Metadata.
IColumnsRowset::GetColumnsRowset	For more information, see Parameter and Rowset Metadata.
IColumnsInfo::GetColumnInfo	For more information, see Parameter and Rowset Metadata.
IDBSchemaRowset::GetRowset	For details of the affected schema rowsets, see Date and Time and Schema Rowsets.
IRowsetFastLoad	This interface supports the new date/time types, but there is no change to its interface.
ITableDefinition::CreateTable	For more information, see Data Type Support for OLE DB Date and Time Improvements.

See Also

Date and Time Improvements (OLE DB)