1.生成分钟:select to_char(trunc(sysdate) + (rownum - 1) / 24 / 60, 'hh24:mi') TIMELINE from dual connect by rownum <= 60 * 24
2.生成秒:select to_char(trunc(sysdate) + (rownum - 1) / 24 / 60 / 60, 'hh24:mi:ss') TIMELINE from dual connect by rownum <= 60 * 24 * 60