title: Sqlite update DATETIME field not working
body: <p>I am trying to update a DATETIME column in a Sqlite table using the following query.</p>
  
  <pre><code>String query = "UPDATE myTable SET displayed = datetime('now') where _id = " + id;
  database.rawQuery(query, null);
  </code></pre>
  
  <p>I have tested this on both device and emulator but its not working, its not updating the value in the column.</p>
  
  <p>PS: I tried the same query in Sqlite browser and its working there.</p>
  
  <p>Please help me figure out a solution.</p>
  
  <p>Thanks.    </p>