SQL 2008 New Date/Time Data Types

  • Article

newFeatures_secondary

 

New Date/Time Data Types

SQL Server 2008 introduces new date and time data types:

· DATE – a date only type

· TIME – a time only type

· DATETIMEOFFSET – a time zone aware datetime type

· DATETIME2 – a datetime type w/ larger fractional seconds and year range than the existing DATETIME type

The new data types enable applications to have separate data and time types while providing large data ranges or user defined precision for time values.

 

See a Demonstration of these New Data Types!