title: H2 Get Date 1 day old from current time
body: <p>I'm currently working on a really fun problem. I want to get a date that is one day old (from current date) and then compare it to now.</p>
  
  <p>The exact way to do this in PostreSQL is this:</p>
  
  <pre><code> select * from table WHERE date &lt; now() - '1 day'::interval;
  </code></pre>
  
  <p>How do I do this in H2 JDBC? Does anybody know?</p>
  
  <p>Grateful for any assistance!</p>