One of the new data types in SQL Server 2008 is the "DATE".
The DATE data type provides only the date without requiring from the database developers to extract the date from the datetime anymore.
To this end you can just get the date with a single line of code:
select cast(SYSDATETIME() as DATE) as [current_date]
or
select cast(getdate() as DATE) as [current_date]
Isn't that cool? :)
Labels: SQL Server, SQL Server 2008