1、往前20天(包括今天)
select to_date('2019-06-09 12:00', 'YYYY-MM-DD HH24:MI') - (level - 1) as day_sequence
from dual
connect by level <= 20
2、往前20小时
select to_date('2019-06-09 12:00', 'YYYY-MM-DD HH24:MI') - (level - 1)/24 as hour_sequence
from dual
connect by level <= 20
3、往前20分钟
select to_date('2019-06-09 12:00', 'YYYY-MM-DD HH24:MI') - (level - 1)/1440 as minute_sequence
from dual
connect by level <= 20
4、往后xxx天(小时、分钟)
把 “ - (level -1) ”内红色的减号改为“+”即可。。。