oracle sql 获取一个时间范围内所有月份的最后一天的日期

 

--查询20190101至20201231 之间所有月末的日期
select ROWNUM,to_char(add_months(last_day(to_date('20190101','yyyymmdd')),+ROWNUM-1),'yyyymmdd') as lastdate
from dual
connect by ROWNUM <=months_between(to_date('20201231', 'yyyymmdd'), to_date('20190101','yyyymmdd'))