| title | API support for date and time enhancements (Native Client OLE DB provider) |
|---|---|
| description | OLE DB API Support for Date and Time Enhancements (Native Client OLE DB provider) |
| author | markingmyname |
| ms.author | maghan |
| ms.date | 03/06/2017 |
| ms.service | sql |
| ms.topic | reference |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics 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. |