title: H2 - DATEADD for complete day
body: <p>this query will retrieve all records during last 7 days.</p>
  
  <pre><code>SELECT * FROM STATISTICS WHERE TIMESTAMP &gt; DATEADD('DAY',-7, NOW())
  </code></pre>
  
  <p>How can I change the query to include the records from midnight 7 days ago?</p>
  
  <p>ex.</p>
  
  <pre><code>SELECT DATEADD('DAY',-7, NOW())
  </code></pre>
  
  <p>Gives:  <strong>2013-09-25 13:46:54.372</strong></p>
  
  <p>But I would like to have: <strong>2013-09-25 00:00:00.000</strong></p>