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]
select cast(getdate() as DATE) as [current_date]
Isn’t that cool? 🙂
Recommended eBooks on SQL Server: