CODE EXAMPLE FOR SQL

cast datetime to date in sql

SELECT CONVERT(date, getdate());