不懂!怎么有些是0001 有些又是 23:40 ??不是应该00:01吗? 是要从00:00开始到23:59的吗?一次全部输出来吗?这个是获取当前时间:select to_char(sysdate, 'hh24:mi') from dual
这样行不行? select to_char(trunc(sysdate)+(rownum-1)/60/24,'hh24mi') from dual connect by rownum<1441;
楼上你看这个帖子 http://community.csdn.net/Expert/TopicView2.asp?id=4980474 还是这样吧 select to_char(trunc(sysdate)+rownum/1440,'hh24mi') from col where rownum<1441;
是要从00:00开始到23:59的吗?一次全部输出来吗?这个是获取当前时间:select to_char(sysdate, 'hh24:mi') from dual
select to_char(trunc(sysdate)+(rownum-1)/60/24,'hh24mi') from dual connect by rownum<1441;
http://community.csdn.net/Expert/TopicView2.asp?id=4980474
还是这样吧
select to_char(trunc(sysdate)+rownum/1440,'hh24mi') from col where rownum<1441;
col改成all_object