There are many ways to return a Date from a DateTime object
SELECT CONVERT(Date, GETDATE())
SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) returns 2016-07-21 00:00:00.000
SELECT CAST(GETDATE() AS DATE)
SELECT CONVERT(CHAR(10),GETDATE(),111)
SELECT FORMAT(GETDATE(), 'yyyy-MM-dd')
Note th...