Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Different between (sysdate) + 1 and (sysdate + 1)

703283Jun 30 2009 — edited Jul 1 2009
What is the different between (sysdate) + 1 and (sysdate + 1)?
SQL>BEGIN
  dbms_job.submit(JOB => jobnumber,
  WHAT => 'BEGIN INV_BACKEND.Inv_Backend; end;',
  NEXT_DATE => trunc(sysdate),
  INTERVAL => 'trunc(sysdate) + 23/24 + 1' );
COMMIT;
Is this will start the job by follow the sysdate and continue run on tomorrow 23:00?
can give me an example?
thanks
This post has been answered by Hoek on Jun 30 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2009
Added on Jun 30 2009
13 comments
7,868 views