CODE EXAMPLE FOR SQL

sql server current date without time

SELECT CAST (GETDATE() AS DATE)