1.1 如何对时间函数进行加减
SQL>
会话已更改。
SQL> select sysdate, sysdate 1/24, sysdate 1/1440, sysdate 1/86400 from dual;
SYSDATE
------------------- ------------------- ------------------- -------------------
2016-10-20 11:40:28 2016-10-20 12:40:28 2016-10-20 11:41:28 2016-10-20 11:40:29
SQL> select sysdate,sysdate 60/(24*60*60) from dual;
SYSDATE
------------------- -------------------
2016-10-20 11:40:34 2016-10-20 11:41:34
SQL>