From oracle-l-bounce@freelists.org Thu Aug 11 00:58:32 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7B5wWqN027020 for ; Thu, 11 Aug 2005 00:58:32 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7B5tPIP026381 for ; Thu, 11 Aug 2005 00:55:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F2CED1DDA3F; Thu, 11 Aug 2005 00:55:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27863-07; Thu, 11 Aug 2005 00:55:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 524071DD9DE; Thu, 11 Aug 2005 00:55:19 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C59E39.5ECCDD58" Subject: Getting seconds from interval type Date: Thu, 11 Aug 2005 08:56:09 +0300 Message-ID: <5A841A20A9085A4C984EADD0FF97BF3704F42B@ectilex.ectel.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Getting seconds from interval type Thread-Index: AcWeOV6ow0i0sz0vT86HNuRRYkwk4g== From: "Amihay Gonen" To: X-archive-position: 23733 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: AmihayG@ectel.com Precedence: normal Reply-To: AmihayG@ectel.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_FONTCOLOR_RED,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C59E39.5ECCDD58 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi,=20 =20 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.=20 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; =20 but this is cumbersome process , I would like to see something like intervaldstonum(interval,'SECOND') .... =20 Amihay Gonen DBA, 972-3-90021678 =20 =20 ------_=_NextPart_001_01C59E39.5ECCDD58 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Hi,=20
 
I can = easily convert=20 number from interval :

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

NUMTODSINTERVAL(1200,'SECOND')
------------------------------= ---------------------------------------------
+000000000=20 00:20:00.000000000

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

I've = found =20 workaround :

 select extract( SECOND from = numtodsinterval(1200,'SECOND'))+
      &= nbsp;   =20 extract( MINUTE from=20 numtodsinterval(1200,'SECOND'))*60+
     &nbs= p;    =20 extract( HOUR from=20 numtodsinterval(1200,'SECOND'))*60*60+
     &= nbsp;    =20 extract( DAY from numtodsinterval(1200,'SECOND'))*60*60*24
  = from=20 dual;
 

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

 

Amihay = Gonen
DBA,
972-3-90021678

 

 
------_=_NextPart_001_01C59E39.5ECCDD58-- -- http://www.freelists.org/webpage/oracle-l