title: insert datetime in sqlite
body: <p>Hello I'm trying to insert a datetime in a sqlite table my code looks like this and is working, but im wondering if theres an easier solution. the columntype is datetime and from what ive read it expects a date of format yyyy-mm-dd hh:mm:ss.</p>
  
  <pre><code>var year = DateTime.Now.Year;
  var month = DateTime.Now.Month;
  var day = DateTime.Now.Day;
  var hour = DateTime.Now.Hour;
  var minute = DateTime.Now.Minute;
  var seconds = DateTime.Now.Second;
  string date = year + "-" + month + "-" + day + " " + hour + ":" + minute + ":" + seconds;
  cmd.Parameters.Add("@test", date);
  </code></pre>
  
  <p>thank you</p>