mssql get date without time 2012 code example Example: sql server current date without time SELECT CAST (GETDATE() AS DATE)