Redigera

Dela via

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)