title: SQL Server : datetime comparison ignoring few milliseconds
body: <p>I noticed that 2 datetimes are considered equal if one is </p>
  
  <pre><code>2010-12-31 15:13:48.000 
  </code></pre>
  
  <p>and the other </p>
  
  <pre><code>2010-12-31 15:13:48.001.
  </code></pre>
  
  <p>I thought in the beginning that it was rounding up or down to nearest full seconds but it turned out </p>
  
  <pre><code>2010-12-31 15:13:48.002 
  </code></pre>
  
  <p>registers the difference correctly.</p>
  
  <p>Any idea why this happens?</p>