title: What should be a default datetime value?
body: <p>I am inserting Excel Sheet records in my <code>DataTable</code> in <code>c#</code> and passing this DataTable to an SQL <code>stored procedure</code>. In my c# code I have put certain checks for <code>empty</code> data cells of Excel sheet to avoid Exceptions. But It seems like I am missing something while giving a <code>default</code> value for my SQL <code>Date</code> field.</p>
  
  <pre><code>string InvoiceDate = (row.Cells[3].Text == "&amp;nbsp;") ? "0/00/0000 00:00:00 AM" : (row.Cells[3].Text);
  </code></pre>
  
  <p>And I get the following error:</p>
  
  <blockquote>
    <p>String was not recognized as a valid DateTime.Couldn't store
    &lt;0/00/0000 00:00:00 AM> in InvoiceDate Column.  Expected type is
    DateTime.</p>
  </blockquote>
  
  <p><strong>Edited -</strong> 
  Declaration of SQL field [InvoiceDate]</p>
  
  <pre><code>[InvoiceDate] [date] NOT NULL
  </code></pre>
  
  <p>Please don't suggest inserting <code>null</code> as I cannot Insert <code>null</code> for this column. </p>