title: DatetimeOffset and Sqlite
body: <p>I'm trying to implement a Data Access Layer against a Sqlite database. One of my tables contains a datetime field. </p>
  
  <p>I have a problem in inserting data into this datetime field.</p>
  
  <pre><code>cmd.CommandText = string.Format(
                          "INSERT INTO Orders(" +
                              "OrderId, " +
                              "Status, " +
                              "CreationTime, " +
                              "LastModification, " +
                              "CreatorName) " +
                          "VALUES(@orderId,@status,@creation,@modification,@creator)";
                      cmd.Parameters.AddWithValue("@orderId", orderId);
                      cmd.Parameters.AddWithValue("@status", status);
                      cmd.Parameters.AddWithValue("@creation", creationTime);
                      cmd.Parameters.AddWithValue("@modification", lastModificationTime);
                      cmd.Parameters.AddWithValue("@creator", creatorName);
  </code></pre>
  
  <p>My table creation:</p>
  
  <pre><code>cmd.CommandText = "CREATE TABLE IF NOT EXISTS Orders(" +
                                    "OrderId TEXT PRIMARY KEY NOT NULL, " +
                                    "Status TEXT, " +
                                    "CreationTime DATETIME, " +
                                    "LastModification DATETIME, " +
                                    "CreatorName TEXT)";
  </code></pre>