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 -> Invalid Interval

Invalid Interval

From: RJ <ridwan.jeena_at_gmail.com>
Date: 18 Sep 2006 00:12:09 -0700
Message-ID: <1158563529.644493.84480@k70g2000cwa.googlegroups.com>


Hi all,

I have a column in a table (Fixed_dur) with data in the format dd hh:mm:ss. I want to copy this data to another column (Durarion) of which the data type is interval day(2) second(6). when i try updating the duration column i get the error: Oracle Error : ORA-01867 the interval is invalid.

Some of the fields have copied, and i cant see how the other fields data is wrong.
The minutes/seconds are not over 59 and hours are under 24.

what could be the problem??

Thanks in advance.. Received on Mon Sep 18 2006 - 02:12:09 CDT

Original text of this message

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