1、获取当前年月往前往后n个月
--往前
select to_char(ADD_MONTHS(sysdate,-(LEVEL-1)),'yyyy-MM') from NY
dual
connect by level <=6
--往后
select to_char(ADD_MONTHS(sysdate,(LEVEL-1)),'yyyy-MM') from NY
dual
connect by level <=6
level后小于几代表范围
2、判断两个日期的月份差距:会精确到小数
select MONTHS_BETWEEN(sysdate,to_date('2019-12','yyyy-mm')) from dual