Oracle获取时间段内的各月底日期

select last_day(add_months(date'2019-07-01',rownum-1)) busi_dt
from dual
connect by rownum<=months_between(date'2020-05-31',date'2019-07-01')+1
order by busi_dt;

  

 

posted @ 2020-08-13 10:11  Ayumie  阅读(1313)  评论(0编辑  收藏  举报