How Oracle can perform simple plus and minus operations on time

We need to set the time interval when we use the Dbms_job package for timed job, so we need to know the basic method of adding and reducing time.

Sql> AlterSessionSetNls_date_format='YYYY-MM-DD Hh24:mi:ss'; The session has changed. SQL> SelectSysdate, Sysdate+1/ -, Sysdate+1/1440, Sysdate+ 1/86400  fromdual;--one hour, one minute, one second sysdate sysdate+1/ -Sysdate+1/1440Sysdate+1/86400------------------- ------------------- ------------------- ------------------- the- -- - xx: -: the  the- -- -  on: -: the  the- -- - xx: -: the  the- -- - xx: -: +SQL> SelectSysdate,sysdate+  -/( -* -* -) fromdual;--Add a minute sysdate sysdate+ -/( -* -*6)------------------- ------------------- the- -- - xx: -: $  the- -- - xx: -: $

The basic usage of the Dbms_job package is referenced below.

Http://www.cnblogs.com/princessd8251/articles/3829430.html