Date/Time Improvements (ODBC)
SQL Server 2008 introduced 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 SQL Server Native Client support for the new date and time data types, see Date/Time Improvements. For a sample demonstrating ODBC date/time support, see Use Date and Time Types.
For more general information about date and time data types, see datetime (Transact-SQL).