title: Database and DataTable DateTime format confusion
body: <p>I want to store a <code>DateTime.Now</code> from my WPF C# application to a <code>DateTime</code> column in <strong>SQL CE</strong> Database.</p>
  
  <p>I am inserting <code>DateTime.Now.ToString("yyyy-mm-dd HH:mm:ss")</code> then I get the following error:</p>
  
  <p><strong>String was not recognized as a valid DateTime.Couldn't store &lt;2011-54-06 18:54:47> in DateTime Column.  Expected type is DateTime.</strong></p>
  
  <p>How to store <code>DateTime</code> in a specific format to <strong>SQL CE</strong>?</p>
  
  <p><strong>[EDIT]</strong></p>
  
  <p>Correction made to: <code>DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")</code></p>
  
  <p>However, after I insert and populate the data to a <code>DataGrid</code>. It shows <strong>2011-54-06 18:54:47</strong> in stead of <strong>yyyy-MM-dd HH:mm:ss</strong> format. I specify the format to be insert to database but it seem SQL CE has its own way of storing. Why?</p>