Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL database in Microsoft Fabric
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. |