title: Why when I insert a DateTime null I have "0001-01-01" in SQL Server?
body: <p>I try to insert the value null (DateTime) in my database for a field typed 'date' but I always get a <em>'0001-01-01'</em>. I don't understand, this field "allow nulls" and I don't know why I have this default value.</p>
  
  <p>I'm using C# asp .net with MVC (Entity Framework), this is my code :</p>
  
  <pre><code>Budget_Synthesis newBS = new Budget_Synthesis
  {
      Budget_Code = newBudgetCode,
      Last_Modified_Date = null
  };
  db.Budget_Synthesis.AddObject(newBS);
  </code></pre>
  
  <p>Last_Modified_Date is typed System.DateTime? so I don't know why they change this 'null'.</p>
  
  <p>If I try to display the value on my application I get <code>01/01/0001 00:00:00</code></p>
  
  <p>And <code>0001-01-01</code> with SSMS</p>
  
  <p>Someone can explain me why I can't get a real 'NULL' ?</p>
  
  <p>Best regards</p>