Re: Convert DBA_JOBS.INTERVAL to date

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 15 Mar 2004 09:56:44 -0000
Message-ID: <40557ddc$0$3311$ed9e5944@reading.news.pipex.net>

what is wrong with select next_date from dba_jobs?

incidentally one thing that does make intervals easier to read is not to reduce the fractions. There are 1 day, 24 hours,1440 minutes or 86400 seconds in a day so

10/1440 = ten minutes
12/24 = 12 noon
30/86400 = 30 seconds

etc. this is (once you get used to it much easier than)

0.006944444
0.5
0.0000347222

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Spendius" <spendius_at_muchomail.com> wrote in message
news:aba30b75.0403150057.42f50acb_at_posting.google.com...


> Hi,

> Do you see a way of converting strings looking like

> > "/*MINUIT*/ TRUNC(SYSDATE)+ 1"

> > "/*5:MINS*/ SYSDATE+1/288"

> > "/*04:00AM*/ TRUNC(SYSDATE)+1.166666"

> > "sysdate + 10/1440"

> to display their real date value ?

>

> When doing

> SQL> alter session set nls_date_format='yyyymmdd hh24:mi';

> SQL> SELECT ???(INTERVAL), interval FROM DBA_JOBS;

>

> I'd like to see:

>    ???(INTERVAL)         INTERVAL

> ---------------- ----------------

> 20040315 10:13   sysdate + 10/720

>

> Thanks.

> Spendius

Received on Mon Mar 15 2004 - 03:56:44 CST