例如:获取'2020-04-01'~'2020-04-02'之间的日期
--获取'2020-04-01'~'2020-04-02'
select to_char(to_date('2020-04-01','yyyy-MM-dd')+rownum-1,'yyyy-MM-dd')day_id
from dual
connect by rownum<=to_date('2020-04-02','yyyy-MM-dd')-to_date('2020-04-01','yyyy-MM-dd')+1
结果如图: