sql 查询一段时间区间内的值

1、sql 查询一段时间区间内的值

select to_char(to_date('-03-02','yyyy-mm-dd')+level-1,'yyyy-mm-dd') as day_value

from dual

connect by level <=to_date('-3-19','yyyy-mm-dd')-to_date('-03-02','yyyy-mm-dd')+1

2、sql查询时间 根据时间范围大小

SELECTto_char (ADD_days (curdate(), -LEVEL+1), 'YYYY-MM-DD') day_valueFROM DUAL connect BY LEVEL <= '30'