title: Why is SQL Server losing a millisecond?
body: <p>I have a table structured like this:</p>
  
  <pre><code>CREATE TABLE [TESTTABLE]
  (
      [ID] [int] IDENTITY(1,1) NOT NULL,
      [DateField] [datetime] NULL,
      [StringField] [varchar](50),
      [IntField] [int] NULL,
      [BitField] [bit] NULL
  )
  </code></pre>
  
  <p>I execute the following code:</p>
  
  <pre><code>BEGIN 
     INSERT INTO TESTTABLE (IntField, BitField, StringField, DateField) 
     VALUES ('1', 1, 'hello', {ts '2009-04-03 15:41:27.378'});  
  
     SELECT SCOPE_IDENTITY()  
  END
  </code></pre>
  
  <p>And then </p>
  
  <pre><code>select * from testtable with (NOLOCK)
  </code></pre>
  
  <p>and my result shows:</p>
  
  <pre><code>2009-04-03 15:41:27.*377*
  </code></pre>
  
  <p>for the <code>DateField</code> column.</p>
  
  <p>Any ideas why I seem to be losing a millisecond??</p>