Re: PL/SQL Intervals are dizzy

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 - 14:10:51 CDT