1.求当年天数的sql语句
SELECT ADD_MONTHS(TRUNC(SYSDATE, 'YYYY'), 12) - TRUNC(SYSDATE, 'YYYY') days
FROM DUAL
2.求当月天数的sql语句
SELECT to_number(to_char(last_day(trunc(SYSDATE)), 'DD')) from dual
3.求指定月天数的sql语句
select to_number(add_months(trunc(to_date('2013-06-17 10:09:02',
'yyyy-fmmm-dd hh24:mi:ss'), 'mm'), 1) - trunc(to_date('2013-06-17 10:09:02',
'yyyy-fmmm-dd hh24:mi:ss'), 'mm')) from dual;