Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.14 KB | None | 0 0
  1. declare @firstDay date
  2. set @firstDay = (SELECT DATEADD(MM, DATEDIFF(MM, '01/01/2000', DATEADD(MM, -1,GETDATE())), '01/01/2000'))
  3. SELECT @firstDay
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement