Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DATEADD(DAY,
- CASE
- (DATEPART(WEEKDAY, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)) + @@DATEFIRST - 1) % 7
- WHEN 6 THEN 2
- WHEN 7 THEN 1
- ELSE 0
- END,
- DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)
- SELECT DATEADD(DAY,
- CASE
- (DATEPART(WEEKDAY, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)) + @@DATEFIRST - 1) % 7
- WHEN 6 THEN 2
- WHEN 7 THEN 1
- ELSE 0
- END,
- DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement