SQL: Setting DateTime Value to Zero

–using DATEDIFF can set the time portion of your DateTime value to zeros –Handy!

DECLARE @Day DATETIME

SET @Day = DATEADD(DAY, -7, DATEDIFF(Day, 0, GETDATE()))