1
Answer

How to get previous month/year in SQL Server

Jes Sie

Jes Sie
4y
7.6k
1
I have this query in my SQL Server :
  1. select right(convert(varchar(10),getdate(),103),7)  
which gaves a result of = 04/2020.
 
Now, how do I get the previous month's result (03/2020)?
 
 Thanks, everyone for your suggestions.
Answers (1)
Next Recommended Forum