SQL Server 2008 -- New Date and Time Data Types

●The date, time, datetime2, and datetimeoffset types are four new data types in SQL Server 2008 for storing dates and times, which you should now begin using for new database development in lieu(替代) of the traditional datetime and smalldatetime data types.

1.Separation of Dates and Times： Date (3 Bytes) 、Time

2.More Portable Dates and Times：datetime2  can store dates from 1/1/0001 to 12/31/9999

3.Time Zone Awareness：datetimeoffset

4.New and Changed Functions

5.Date and Time Accuracy, Storage, and Format