--查询20190101至20241231 之间所有月末的日期
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('20241231', 'yyyymmdd'),
to_date('20190101', 'yyyymmdd'))
oralce 获取每个月的月末日期
最新推荐文章于 2024-02-01 09:40:12 发布