Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @LastSaturday DATETIME = (SELECT DATEADD(DAY, -2 - (DATEPART(dw, @hourStartTime) + @@DATEFIRST - 2) % 7, @hourStartTime))
- DECLARE @LastSunday DATETIME = (SELECT DATEADD(DAY, 1, @LastSaturday))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement