Monthly Archives: January 2020

More Date Logic

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) — … Continue reading

Posted in Uncategorized | Leave a comment