title: DATE_SUB and DATE_ADD in H2 for MySQL
body: <p>I am using MySQL as my database and H2 for testing. I am also using playframework 2.3.x and Scala, but I think does not matter for the question purpose.</p>
  
  <p>H2 has a conflict with some functions that I am using in a query</p>
  
  <pre><code>SELECT *
  FROM subscriptions
  WHERE active_until &gt;= (DATE_SUB(CURDATE(), INTERVAL 3 DAY))
  AND active_until &lt;= (DATE_ADD(CURDATE(), INTERVAL 1 DAY))
  AND status = "ACTIVE"
  </code></pre>
  
  <p>The functions that cause the problem are DATE_SUB and DATE_ADD.</p>
  
  <p>Is there a workaround where I can make this work or change the query without breaking it for mysql?</p>