title: SQL Server 2014 insert/update smalldatetime value with seconds
body: <p>I'm having a strange issue with the smalldatetime data type in SQL Server.</p>
  
  <p>I have a very basic table</p>
  
  <pre><code>create table datetest (
      value   smalldatetime   not null
  )
  </code></pre>
  
  <p>And when I run the following</p>
  
  <pre><code>insert into datetest
  values ('2016-12-29 21:30:00');
  </code></pre>
  
  <p>I see the value is <strong>2016-12-29 21:30:00</strong></p>
  
  <p>Then when I run the following</p>
  
  <pre><code>update datetest
  set value = '2016-12-29 21:31:30'
  </code></pre>
  
  <p>I see the value is <strong>2016-12-29 21:31:00</strong></p>
  
  <p>It did not include the seconds. Why is this?</p>