title: SQLite command to insert current datetime not working through c#
body: <p>I am trying to insert current date in my table from a c# application, i am doing this the following way:</p>
  
  <pre><code>sqlite_cmd.CommandText = "INSERT INTO tablename (column1,creation_date) VALUES ('abcd_" + (id) + "',CURRENT_TIMESTAMP);";
                  sqlite_cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>But this throws error saying that CURRENT_TIMESTAMP is not a valid field.
  I double checked the above query using sqlite manager plugin for firefox and it seems to work correctly. </p>
  
  <p>P.S. - id in the above query is an int variable that is set by c# application.</p>