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

Home -> Community -> Mailing Lists -> Oracle-L -> Getting seconds from interval type

Getting seconds from interval type

From: Amihay Gonen <AmihayG_at_ectel.com>
Date: Thu, 11 Aug 2005 08:56:09 +0300
Message-ID: <5A841A20A9085A4C984EADD0FF97BF3704F42B@ectilex.ectel.com>


Hi,  

I can easily convert number from interval :

select numtodsinterval(1200,'SECOND') from dual;

NUMTODSINTERVAL(1200,'SECOND')


---
+000000000 00:20:00.000000000



But I've found no place where I can convert interval to number again. 


I've found  workaround :

 select extract( SECOND from numtodsinterval(1200,'SECOND'))+
           extract( MINUTE from numtodsinterval(1200,'SECOND'))*60+
           extract( HOUR from numtodsinterval(1200,'SECOND'))*60*60+
           extract( DAY from numtodsinterval(1200,'SECOND'))*60*60*24
  from dual;
 

but this is cumbersome process , I would like to see something like
intervaldstonum(interval,'SECOND') ....

 

Amihay Gonen
DBA,
972-3-90021678

 

 

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 11 2005 - 00:58:32 CDT

Original text of this message

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