Trunc Date Only No Time SQL Server

SQL Server > Built-in Functions > CAST > Trunc

Trunc date in SQL Server

SELECT Cast(GetDate() AS date) Results:2012-08-18