oracle 取两个日期之间月份差

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;

原文地址:https://www.cnblogs.com/pb272860193/p/12162251.html