1:取当前月与某月 月份差
select trunc(months_between(sysdate,to_date(to_char(xrcc004,'yyyymm'),'yyyymm'))) from dual
2:取当某月与某月 月份差(大月份在前)
select trunc(months_between(to_date('201912','yyyymm'),to_date('201812','yyyymm'))) from dual;
1:取当前月与某月 月份差
select trunc(months_between(sysdate,to_date(to_char(xrcc004,'yyyymm'),'yyyymm'))) from dual
2:取当某月与某月 月份差(大月份在前)
select trunc(months_between(to_date('201912','yyyymm'),to_date('201812','yyyymm'))) from dual;