title: Correct DateTime format in SQL Server CE?
body: <p>I have a C# <code>DateTime</code> class and wanted to know how I need to format it in a SQL Server CE query to insert it into the database, I was hoping to have both the date and time inserted in. Currently when I try variations thereof I get invalid format exceptions.</p>
  
  <p>Current format I'm using is: <code>dd/MM/yyyy</code>, was hoping to do something like <code>dd/MM/yyyy hh:mm:ss</code>.</p>
  
  <p>The way I'm trying to do the insert is like so:</p>
  
  <pre><code> ( ( DateTime )_Value ).ToString( "dd/MM/yyyy hh:mm:ss" )
  </code></pre>
  
  <p>Obviously <code>hh:mm:ss</code> isn't working, if that isn't there <code>dd/MM/yyyy</code> executes successfully in the query.</p>
  
  <p>I've tried a few formats including what I've found on google but none have worked so far...</p>