title: Deleting a row in SQLite after a certain amount of time
body: <p>I have a table with one row. I would like to delete this row after one hour. Within this row, I store the timestamp with the specified format as 'COULMN_DATE'. I got the query that should work from here: </p>
  
  <p><a href="https://stackoverflow.com/questions/20785381/delete-a-row-in-a-table-after-an-hour-it-is-inserter-using-sql-query">Delete a row in a table after an hour it is inserter using sql query</a></p>
  
  <p>And I call it like this in my <code>onCreate()</code> function within my databaseHandler class, and I made sure I also updated my database version beforehand. I replaced hour to minutes for checking purposes:</p>
  
  <pre><code> db.execSQL("DELETE FROM " + TABLE_PRODUCTS +" 
                WHERE "+ COLUMN_DATE +" &lt; DATETIME('NOW', '-1 minutes');");
  </code></pre>
  
  <p>But after inserting a timestamp, waiting a couple of minutes, and then restarting the application to check whether the data was deleted, it was still there. Is it because I am calling it in the wrong place? If so, where should this query be done?</p>