sql server current date without time
snippet in sql

sql server current date without time

user978

SELECT CAST (GETDATE() AS DATE)