title: Inserting datetime with milliseconds into SQL Server table issue
body: <p>I came across something that I think has to do with time resolution in SQL.
  Here's an example I've used:</p>
  
  <pre><code>CREATE TABLE #table
  (
      DTstamp DATETIME NOT NULL
  )
  
  INSERT INTO #table VALUES ('1 apr 2016 15:01:02:129')
  
  SELECT DTstamp FROM #table
  
  DROP TABLE #table
  </code></pre>
  
  <p>The result from <code>SELECT</code> shown in SQL Server Management Studio is off by 0.001 in this case:</p>
  
  <pre><code>2016-04-01 15:01:02.130
  </code></pre>
  
  <p>When trying multiple values, the result is shown is usually within 0.003 sec of the inserted time. Does anyone know where the discrepancy come from?</p>
  
  <p>SQL Version:</p>
  
  <pre><code>Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64) 
  Oct 20 2015 15:36:27 
  Copyright (c) Microsoft Corporation
  Standard Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1)
  </code></pre>