Getting seconds from interval type

  • From: "Amihay Gonen" <AmihayG@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 11 Aug 2005 08:56:09 +0300

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2005