1、获取当月的最后一天last_day()
SELECT to_char(last_day(sysdate),'dd') FROM dual
2、获取下一个月的最后一天 add_months()
SELECT to_char(last_day(add_months(sysdate,1)),'dd') AACount FROM dual
3、CASE语句
SELECT AA, BB, CC,
CASE TRUNC((SYSDATE-AA))
WHEN 0 THEN 1
ELSE TRUNC((SYSDATE-AA))
END AS DIFF
FROM DD