From: kennedy-downwithspammersfamily@attbi.net   
      
   "Wit Serdakovskij"  wrote in message   
   news:20040702104526.GA26790@tormoz.net...   
   > Hello, Joe,   
   >   
   > [...]   
   >   
   > > 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.   
   >   
   > --   
   > wbr,   
   > Wit.   
      
   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.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)