Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Convert DBA_JOBS.INTERVAL to date

Convert DBA_JOBS.INTERVAL to date

From: Spendius <spendius_at_muchomail.com>
Date: 15 Mar 2004 00:57:54 -0800
Message-ID: <aba30b75.0403150057.42f50acb@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 - 02:57:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US