SELECT
TO_NUMBER(ADD_MONTHS(TO_DATE('2008-02-02','YYYY-MM-DD'),1) - TO_DATE('2008-02-02','YYYY-MM-DD')) AS DAYSUM
FROM DUAL;
也可以用LAST_MOUTH这个方法
SELECT
TO_NUMBER(ADD_MONTHS(TO_DATE('2008-02-02','YYYY-MM-DD'),1) - TO_DATE('2008-02-02','YYYY-MM-DD')) AS DAYSUM
FROM DUAL;
也可以用LAST_MOUTH这个方法