title: How to structure my query in sqlite?
body: <p>I would like to retrieve today's data. At the moment I have something like <code>SELECT * FROM  myTable  WHERE timeStamp&gt;DATETIME('NOW','-1 DAY')</code> but this gives me results from now to 24hrs back, not just today (i.e. no matter how many hours have passed since 00:00). Using the same logic I want to retrieve data for just yesterday, and for the this week. </p>
  
  <p><strong>[EDIT]</strong>
  By the term this week i mean.. if today is Thursday, i want to show results from monday or Sunday (it doesnt matter) upto now.</p>