1、sql 查询一段时间区间内的值
select to_char(to_date('2022-03-02','yyyy-mm-dd')+level-1,'yyyy-mm-dd') as day_value
from dual
connect by level <=to_date('2022-3-19','yyyy-mm-dd')-to_date('2022-03-02','yyyy-mm-dd')+1
2、sql查询时间 根据时间范围大小
SELECT to_char (ADD_days (curdate(), -LEVEL+1), 'YYYY-MM-DD') day_value FROM DUAL connect BY LEVEL <= '30'