From: fvanbortel@netscape.net   
      
   Danes wrote:   
      
   > Maybe I am just dizzy but I thought that 600 seconds is 10 minutes...   
   > Obviously not! Or maybe PL/SQL is just dizzy.   
   >   
   > SQL> declare   
   >   2   blah1 interval day to second :=  interval '600' second;   
   >   3  blah2 interval day to second := interval '10' minute;   
   >   4  begin   
   >   5  if blah1 <> blah2 then   
   >   6  dbms_output.put_line('plsql is shit');   
   >   7  else   
   >   8   dbms_output.put_line('maybe not');   
   >   9   end if;   
   >  10  end;   
   >  11  /   
   > plsql is shit   
   >   
   > PL/SQL procedure successfully completed.   
   >   
   > SQL> declare   
   >   2   blah1 interval day to second :=  interval '601' second;   
   >   3  blah2 interval day to second := interval '10' minute;   
   >   4  begin   
   >   5  if blah1 < blah2 then   
   >   6  dbms_output.put_line('plsql is really shit');   
   >   7  else   
   >   8  dbms_output.put_line('maybe not');   
   >   9   end if;   
   >  10  end;   
   >  11  /   
   > plsql is really shit   
   >   
   > PL/SQL procedure successfully completed.   
   >   
   > SQL>   
      
   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   
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)