OLE DB API Support for Date and Time Enhancements (Native Client OLE DB provider)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
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 and ODBC). |
| 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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for