Look at Date and Time data types in SQL Server 2008

SQL Server 2008 provides new datatypes to work with date and time values easily.

SQL Server 2008 provides new date and time datatypes for database desginers to work easily with dates without times[viceversa], time zones and future dates.