CODE EXAMPLE FOR SQL

How to return only the Date from a SQL Server DateTime datatype

SQLServer 2008 now has a 'date' data type which contains only a date with no time component. Anyone using SQLServer 2008 and beyond can do the following:

SELECT CONVERT(date, GETDATE())