title: how to query Datetime object by date?
body: <p>i want to query a table according to a particular date, but the problem is the datatype of that field is datetime </p>
  
  <pre><code>select  * from  Supplier  where modified_Date='2011-05-07 12:52:16.830' 
  </code></pre>
  
  <p>this query is returning result</p>
  
  <p>but </p>
  
  <pre><code> select  * from  Supplier  where modified_Date='2011-05-07' 
  </code></pre>
  
  <p>there is no result</p>