計算時間的例子

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
會話已更改。
SQL> select sysdate,sysdate+1/24,
  2  sysdate+1/1440,
  3  sysdate+1/86400
  4  from dual;
SYSDATE             SYSDATE+1/24        SYSDATE+1/1440      SYSDATE+1/86400    
------------------- ------------------- ------------------- -------------------
2010-06-12 12:42:58 2010-06-12 13:42:58 2010-06-12 12:43:58 2010-06-12 12:42:59

SQL> select sysdate,
  2  sysdate+60/(24*60*60) from dual;
SYSDATE             SYSDATE+60/(24*60*6      
------------------- -------------------                            
2010-06-12 12:44:35 2010-06-12 12:45:35