How to select date without time in SQL?

Question

When I select date in SQL it is returned as `2011-02-25 21:17:33.933`. But I need only the Date part, that is `2011-02-25`. How can I do this?

Answer 1

SQLServer 2008 now has a 'date' data type which contains only a date without the time.

Prior versions of SQLServer would be as follows...

SELECT CONVERT(date, GETDATE())