title: I need the SQLite equivalent of MySQL for working with unix timestamps
body: <p>I'm using unix timestamps with SQLite and storing them as an integer. My problem is that I am trying to select records for today based on their unix timestamps and I have no clue what functions to use.</p>
  
  <p>Here is what I would use in MySQL:</p>
  
  <p><code>where date_format(from_unixtime(COLUMN_DATE), '%Y-%m-%d')= date_format(now(), '%Y-%m-%d')</code></p>
  
  <p>However when I try to use these functions I'm getting errors in the log telling me they don't exist for SQLite.</p>
  
  <p>How do I write this for SQLite?</p>