New DATETIME Data Types in SQL 2008
With new versions of any software comes the new features. That brings us some benefits when we work only with new software version but it might bring us some headaches if we have to maintain compatibility with older versions. Anyhow, we have to utilize the advantages of new versions where ever we can so the first step toward that goal is to learn what the new features are and what they offer.
One of the new function’s regarding DATETIME in SQL Server 2008 are four new data types introduced. They are DATE, TIME, DATETIMEOFFSET and DATETIME2.
The great article which describes what those data types offer and what are the changes in standard function libraries is:
http://www.sql-server-performance.com/articles/dev/datetime_2008_p1.aspx
It provides very detailed explanation for most of the new functionalities that those new data types bring. I highly recommend it.