From: wit_no@spam_dba.kiev.ua   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)