CODE EXAMPLE FOR SQL

mssql datetime to date

SELECT CAST(GETDATE() AS DATE) date;