select * from (select to_char(t, 'yyyy') a, to_char(t, 'mm') b, to_char(t, 'dd') c from ( select decode(level, 1, trunc(to_date('20160101','yyyymmdd'), 'dd'), add_months(trunc(to_date('20160101','yyyymmdd'), 'mm'), 2 - 1 * level) - 1) t from dual connect by level < 5 )d) t_1
oracle找一下今天日期,上n个月的年月
最新推荐文章于 2023-12-01 11:09:57 发布