方法一:
select trunc(last_day(sysdate))-trunc(add_months(last_day(sysdate),-1)) from dual;
方法二:
SELECT to_number(to_char(last_day(sysdate),'dd')) FROM dual;
select trunc(last_day(sysdate))-trunc(add_months(last_day(sysdate),-1)) from dual;
方法二:
SELECT to_number(to_char(last_day(sysdate),'dd')) FROM dual;