title: How to query in sqlite for a particular date?
body: <p>When I give select date('now', 'start of month') sqlite returns first day of the current month,But When I try</p>
  
  <p><code>select * from mytable where trandate in ( select date(;now', 'start of day'))</code> </p>
  
  <p>it returns no rows all the data id present for the day.
  When I use 
  select * from mutable where trandate = 20140401 it returns correctly. But I want to query on dates which I do not know </p>
  
  <p>e.g.</p>
  
  <pre><code>SELECT *
  FROM mytable
  WHERE trandate IN (
    SELECT date(;
  
  now', '-9 years', '+5 days'))
  </code></pre>
  
  <p>In this case I do not know which date will be 9 years back + 5 days
  Please tell me how to query for dates using modifiers such as above in search criteria</p>