XPost: comp.databases.oracle.misc, microsoft.public.sqlserver.programming   
   From: george.dainis@bluecorner.com   
      
   In my database table there is a datetime column which can obviously contain a   
   timestamp   
   (in the format YYYY-MM-DD HH:MM:SS.NNN).   
      
   Now I want to get all those records which have a date of lets say 2005-02-03   
   regardsless of   
   their time value.   
      
   Ok, I could do this by statement like   
      
   SELECT * FROM MYTAB WHERE MYDATE >= '2005-02-03 00:00:00.000' AND MYDATE <=   
   '2005-02-03 23:59.59.999'   
      
   but this is rather inconvenient. I feel that there must be a shorter version   
   like   
      
   SELECT * FROM MYTAB WHERE MYDATE = '2005-02-03 **:**:**.***'   
      
    or a built-in fuction like:   
      
   SELECT * FROM MYTAB WHERE datepartonly(MYDATE) = '2005-02-03'   
      
   How does this work?   
      
   George   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)