生成每15分钟一个点的结果集
select x.time_point,level from(
select to_date('2008-05-01 00:00', 'yyyy-mm-dd hh24:mi') + level / (24 * 4) -
1 / (24 * 4) as time_point
from dual
connect by level <= (to_date('20080502', 'yyyymmdd') - to_date('20080501', 'yyyymmdd') + 1)*24*4) x;