Re: PL/SQL Intervals are dizzy

From: Danes <sandra_danes_at_dangerous-minds.com>
Date: 26 Aug 2004 12:10:51 -0700
Message-ID: <662764.0408261110.4efc59f2_at_posting.google.com>


Frank van Bortel <fvanbortel_at_netscape.net> wrote in message
>
> If I understand correctly, you must do the math
> yourself (from the SQL Reference, on Interval):
>
> The valid range of values for the trailing field are as follows:
>
> HOUR: 0 to 23
> MINUTE: 0 to 59
> SECOND: 0 to 59.999999999
>
> Although I get it to work with less than 100 seconds as well...
> Just print blah1 (it's 0 when greater than 99 specified)
>
> Also, I tested with 9.2.0.4, which seem to have some bugs
> (many examples did not work...) in this area

I did try to print blah1 before and saw that. That is how I debugged my problem in the first place. Just found it kind of strange and thought there may be a reason for it. Then I found MINUTE and my code worked!

If you give a varchar2 a range too big the compiler complains. I would *at least* expect the same for intervals.

oh well, thanks for chilling and giving me an answer... maybe I will hit the Ora docs and see what they have to say! Received on Thu Aug 26 2004 - 21:10:51 CEST

Original text of this message