title: SQL Server remove milliseconds from datetime
body: <pre><code>select *
  from table
  where date &gt; '2010-07-20 03:21:52'
  </code></pre>
  
  <p>which I would expect to not give me any results... EXCEPT I'm getting a record with a datetime of <code>2010-07-20 03:21:52.577</code></p>
  
  <p>how can I make the query ignore milliseconds?</p>