oracle中取两个日期之间相差月份的方法:
SELECT CEIL(MONTHS_BETWEEN(TO_DATE('2010-12-31', 'YYYY-MM-DD'),
TO_DATE('2010-10-03', 'YYYY-MM-DD'))) YF
FROM DUAL;
SELECT CEIL(MONTHS_BETWEEN(TO_DATE('2010-12-31', 'YYYY-MM-DD'),
TO_DATE('2010-10-03', 'YYYY-MM-DD'))) YF
FROM DUAL;