oracle 时间函数操作

1. 时间以分钟的方式依次向前推移

Select to_char(to_date('20151110 101933', 'YYYYMMDD HH24:MI:SS') - (level - 1) / 1440, 'YYYYMMDD HH24:MI:SS') as minute_sequence
  from dual
connect by level <= 120;

SELECT TO_CHAR(TO_DATE('20151110 103345','YYYYMMDD HH24:MI:SS') - (ROWNUM - 1)/(24*60), 'YYYYMMDD HH24:MI:SS' ) sd
FROM DBA_OBJECTS
WHERE ROWNUM <= 40;

2. 时间以小时的方式依次向前推移