title: How to get events in the last 24 hours with SQLite?
body: <p>I have a column with datetime entries, and I would like to get all the items from the last 24 hours.  Right now I'm trying:</p>
  
  <pre><code>SELECT * FROM " + SQLHelp.LOG_TABLE + " WHERE " + SQLHelp.TIME_COLUMN + "&gt; datetime('now','-1day')
  </code></pre>
  
  <p>where <code>SQLHelp.LOG_TABLE and SQLHelp.TIME_COLUMN</code> are the names of the table and column respectively.</p>