declare @ThisDate datetime; set @ThisDate = getdate(); select dateadd(dd, datediff(dd, 0, @ThisDate), 0) — Beginning of this day select dateadd(dd, datediff(dd, 0, @ThisDate) + 1, 0) — Beginning of next day select dateadd(dd, datediff(dd, 0, @ThisDate) – 1, 0) — Beginning of previous day select dateadd(wk, datediff(wk, 0, @ThisDate), 0) — Beginning of this week [...]
