Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select (dateadd(month,datediff(month,(0),getdate())-1,(0)));
- select dateadd(month, -1, GETDATE());
- SELECT DateAdd(month, -1, Convert(date, GetDate()));
- SELECT Convert(datetime, DateAdd(month, -1, Convert(date, GetDate())));
- select Cast(Cast(dateadd(month, -1, GETDATE()) as Date) as Datetime);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement