From: wit_no@spam_dba.kiev.ua   
      
   [...]   
      
   > > > I get today 30-JUN-04. If there are 10 records in X including 3 from   
   > > > today, why does   
   > > >   
   > > > 'select count(1) from X where datestamp < '01-JUL-04' return 10 but   
   > > >   
   > > > 'select count(1) from X where datestamp <= '30-JUN-04' returns 7?   
   > >   
   > > It's simple. Really your first query gets all the JUNE records. The   
   > > second query gets record with datestamp less than '01-JUN-04 00:00:00'   
   > > and records with datestamp equal to '01-JUN-2004 00:00:00' (not with   
   > > 01-JUN-04 with some time portion). Again, '01-JUN-04 14:14:14' is   
   > > greater than '01-JUN-04'.   
   > >   
   > > [...]   
   > >   
   > > Be careful with DD-MON-YY. Use DD-MON-RR (or DD-MON-YYYY) instead.   
      
   [...]   
      
   > Don't use an implicit conversion of a string to a date!  Use to_date()   
   > instead. You have bug in your code just waiting to bite you.   
      
   Agreed. That's just a notation from replied message...   
      
      
   --   
   wbr,   
   Wit.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)