oracle 前10分鐘 後10分鐘

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/，如需轉載，請註明出處，否則將追究法律責任。