title: SQL does not pull records based on exact date
body: <p>I exported records and I want to know which record was exported on a particular day. It does not work. Here is the data if I query it.</p>
  
  <pre><code>* comapny Name *     * date exported *
  ABC Company, Inc    2011-08-01 15:44:52.857
  XYZ Company, Inc    2011-08-01 15:44:52.857
  </code></pre>
  
  <p>I issue this command which does not retrieves the exact matches</p>
  
  <pre><code>select companyname, exporteddate from mytable exporteddate = '2011-08-01' &lt;- does not work
  select companyname, exporteddate from mytable exporteddate like '%2011-08-01%' &lt;-- tried this variation too and many other, did not work
  </code></pre>
  
  <p>The interesting thing is >=, >, &lt;= works. What really is the problem?  The exported date is declared as datetime field.</p>
  
  <pre><code>select companyname, exporteddate from mytable exporteddate &gt;= '2011-08-01' &lt;- this works
  </code></pre>
  
  <p>I am using Windows XP, MS-SQL 2005 SP3 (not exactly but close).</p>