In SQL Server 2008 valid date range has be increased. It can from
0001-01-01 to 9999-01-01.
SYSDATETIMEOFFSET function has been added to get the time zone
offset with the date-time.
In SQL Server 2008 the number of precision for second has been
increased up to 7 which is only 3 in the SQL Server 2005 version.
SWITCHOFFSET is used to set a new time zone.
Also, SQL Server 2008 has added 4 new 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
So maybe in a
few years, we will not need to worry so much about separating out dates and