How to get date only from datetime in T-SQL

Sat Nov 24 2012