SQL date now day
Cast('2016-10-14 00:00:00.000' as datetime)
DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)