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
