update date without time using sql query$ code example

Example: sql server current date without time

SELECT CAST (GETDATE() AS DATE)