are you looking for something like this SELECT extract(year_month from DATE_ADD(curdate(),INTERVAL -1 YEAR));
another example where adding 13 months
SELECT extract(year_month from DATE_ADD(curdate(),INTERVAL 13 MONTH));
1
solved How to get Previous December month of Previous Year