title: sql server bulk insert nulls into time column
body: <p>I'm having trouble inserting null value from a bulk insert statement.</p>
  
  <p>Two columns are nullable and the Id is identity.</p>
  
  <p>The <code>int</code> nullable workd out fine, but the <code>time</code> doesn't.</p>
  
  <ul>
  <li><p>Here the bulk statement:</p>
  
  <pre><code>BULK INSERT Circulation 
  FROM '.....file.cs' 
  WITH ( FIRSTROW = 2, MAXERRORS = 0, FIELDTERMINATOR = ',', 
       ROWTERMINATOR = '', KEEPNULLS)
  </code></pre></li>
  <li><p>Here is an extract of the csv:</p>
  
  <pre><code>ID, IDStopLine, IDException, Hour, PositionHour, Day
  
  ,28, 8, 12:20, 52, 0
  
  ,29, 163, , 1, 
  </code></pre></li>
  </ul>
  
  <p>Meaning that I'm trying to insert nulls in those both columns. The result is ithe int column with NULL and the time column with 00:00:00</p>
  
  <p><img src="https://i.stack.imgur.com/WzcU9.png" alt="enter image description here"></p>