Export (0) Print
Expand All

Date/Time Improvements (OLE DB)

SQL Server 2008 introduces new date and time data types. This section describes how these new types are exposed as extensions in SQL Server Native Client. For an overview of the SQL Server Native Client support for the new date and time data types, see Date/Time Improvements. For a sample, see Use Enhanced Date/Time Features (OLE DB).

For more general information about date and time data types, see datetime (Transact-SQL).

Data Type Support for OLE DB Date/Time Improvements

Provides information about OLE DB (SQL Server Native Client) types that support SQL Server date and time data types.

Metadata (OLE DB)

Contains information about the DBBINDING structure, ICommandWithParameters::GetParameterInfo, ICommandWithParameters::SetParameterInfo, IColumnsRowset::GetColumnsRowset, and IColumnsInfo::GetColumnInfo. Also provides information about updates to OLE DB schema rowsets.

Bindings and Conversions (OLE DB)

Describes the rules for conversion between server and client for both existing and new date types.

Bulk Copy Changes for Enhanced Date/Time Types (OLE DB and ODBC)

Describes date/time enhancements to support bulk copy operations.

OLE DB API Support for Date/Time Enhancements

Describes the OLE DB APIs that support enhanced date/time features.

Comparability for IRowsetFind

Describes date/time types and IRowsetFind.

New Date/Time Features with Previous SQL Server Versions (OLE DB)

Describes the expected behavior when a client application that uses enhanced date and time features communicates with an older version of SQL Server, and when a client compiled with an older version of SQL Server Native Client sends commands to a server that supports enhanced date and time features. 

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft