Skip to Main Content
Forums

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!

Interval column in dba_jobs

user12004815Aug 14 2013 — edited Aug 15 2013

Hello,

My oracle database version is Oracle 10g 10.2.0.4. I have created a few dbms_jobs with interval = 'trunc(sydate) + 1'. How do i interpret the value in the interval column into the actual date value? For example, if the job is running today 08/14/2013, trunc(sysdate) + 1 results in 08/15/2013 and 08/15/2013 is the value I want through a pl/sql program. Any ideas?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2013
Added on Aug 14 2013
12 comments
711 views