oralce 查询一天每隔15分钟一个点 15分钟
select to_char((daybegin + (level - 1) * 15 / 1440), ‘hh24:mi’) as this15time
from (select (trunc(sysdate, ‘dd’)) as daybegin from dual)
connect by level <= 96
例如 每隔5分钟的话,只需要修改 15改成5 level <=改成288
select to_char((daybegin + (level - 1) * 5 / 1440), ‘hh24:mi’) as this15time
from (select (trunc(sysdate, ‘dd’)) as daybegin from dual)
connect by level <=288