Look at Date and Time data types in SQL Server 2008

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.