MSSQL ~ Datetime to Date

SELECT CAST('2010-12-22 10:10:10' AS DATE)

SELECT CAST(FieldName AS DATE)

reference
http://www.sql-server-performance.com/articles/dev/date_time_search_p1.aspx