select add_months(to_date(to_char(sysdate/*可替换为想要查询的月份*/,'yyyy/mm'),'yyyy/mm'),1)-to_date(to_char(sysdate/*可替换为想要查询的月份,于前参数一致*/,'yyyy/mm'),'yyyy/mm')m_num
from dual
七.当年天数
select add_months(trunc(sysdate,'yyyy'),12)-trunc(sysdate,'yyyy') y_num
from dual
八.当月天数
select to_number(to_char(last_day(trunc(sysdate)),'dd'))m_num
from dual
一.获取当年所有日期select trunc(sysdate,'yyyy')+rownum-1 as pday from dual connect by rownum<=add_months(trunc(sysdate,'yyyy'),12)-trunc(sysdate,'yyyy')--where pday<trunc(sysdate)/*如此可查询从当年1号到昨天的日期*/二.获取当月所有日期select trunc(sysdate,'mm')+rownum-1 as pday