sql - Oracle 正确获取月份差异

Question

您好，我在获取当前月份日期的正确差值(不包括当天)时遇到了问题。

即如果运行查询的月份是 2013 年 3 月

那么应该是下面的结果

EXECUTION_DATE, EXEC_DIFF01-FEB-13,  131-JAN-13,  230-JAN-13,  2

however using the below sql statement im getting

EXECUTION_DATE, EXEC_DIFF01-FEB-13,  131-JAN-13,  230-JAN-13,  1

select EXECUTION_DATE,
       floor(MONTHS_BETWEEN (trunc(sysdate,'MM')-1, EXECUTION_DATE))+1 "EXEC_DIFF"
from V_CERT_LIST  
WHERE EXECUTION_DATE < TO_DATE('02/02/2013','DD/MM/YYYY') 
ORDER BY EXECUTION_DATE DESC

请有人能纠正我一段时间以来一直在抨击我的想法吗

谢谢

Answer 1

select EXECUTION_DATE,
       MONTHS_BETWEEN (trunc(sysdate,'MM'), trunc(EXECUTION_DATE,'MM')) "EXEC_DIFF"
from V_CERT_LIST  
WHERE EXECUTION_DATE < TO_DATE('02/02/2013','DD/MM/YYYY') 
ORDER BY EXECUTION_DATE DESC