By now you might have seen on blogs and documentation that there are new datatypes introduced in SQL Server 2008, they are: DATE - ANSI-compliant date data type TIME - ANSI-compliant time data type with variable precision DATETIMEOFFSET - timezone aware/preserved
Read More...