sqlite - get all entries from today
<p>I have an android app with sqlite database which has a column holding the entry creation date in <strong>unix-time format</strong> (<code>DateTime().getMillis() / 1000</code>).</p>

<p>What I want is very simple, to get all the entries from today.</p>

<p>Just to be clear, I mean all entries bigger than at 00:00:00 of today (just after midnight of yesterday). </p>

<p>I guess my timezone should also go in the query somewhere, because unix-time is in UTC.</p>