select to_date('2018-09-01', 'yyyy-MM-dd') + rownum - 1 as dateday
from dual
connect by rownum <= (to_date('2019-01-21', 'yyyy-MM-dd') -
to_date('2018-09-01', 'yyyy-MM-dd'));
Oracle查询一段时间内的每一天
最新推荐文章于 2024-07-07 18:38:50 发布
select to_date('2018-09-01', 'yyyy-MM-dd') + rownum - 1 as dateday
from dual
connect by rownum <= (to_date('2019-01-21', 'yyyy-MM-dd') -
to_date('2018-09-01', 'yyyy-MM-dd'));