SELECT SYSDATE + (ROWNUM - 1) * 10 / 1440 s,
SYSDATE + ROWNUM * 10 / 1440 - 1e-5 e
FROM dual
CONNECT BY ROWNUM < 11
with t as (
select (rownum-1)*10/1440 s,(level*10)/1440 e
FROM dual
CONNECT BY ROWNUM < 11)
select sysdate+s,sysdate+e from t;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11990065/viewspace-758667/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11990065/viewspace-758667/