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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Interval addition..

Re: Interval addition..

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 18 Sep 2006 17:57:16 +0200
Message-ID: <450ec1dd$0$27236$636a55ce@news.free.fr>

"RJ" <ridwan.jeena_at_gmail.com> a écrit dans le message de news: 1158585318.972804.155590_at_i42g2000cwa.googlegroups.com...
| Hi all,
|
| how do i add data in interval day(2) second(6) format?
|
| Thanks in advance..
|

SQL> select interval '00 00:10:57' day(2) to second(6)   2 + interval '00 00:10:41' day(2) to second(6)   3 from dual;
INTERVAL'0000:10:57'DAY(2)TOSECOND(6)+INTERVAL'0000:10:41'DAY(2)TOSECOND(6)



+000000000 00:21:38.000000000

1 row selected.

What is the issue?

Regards
Michel Cadot Received on Mon Sep 18 2006 - 10:57:16 CDT

Original text of this message

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