title: Why can't H2 database parse a timestamp?
body: <p>My project is using Oracle database, and everything works just fine. For the purpose of testing I set up an H2 db. The following query now throws an error:</p>
  <pre><code>&quot;SELECT * FROM ERESIS.ECH_HISFAB f WHERE f.FG_ETAT = 'A' AND TO_DATE(DT_INS) &gt; '30-AUG-18' ORDER BY f.CD_MAT&quot;
  </code></pre>
  <p>error:</p>
  <pre><code>Cannot parse &quot;TIMESTAMP&quot; constant &quot;30-AUG-18&quot;; SQL statement:
  </code></pre>
  <p>I can fix the error by setting up the string like TO_DATE('30-AUG-2018'), but changing the query kind of defeats the purpose since I already am sure the query works (but I need it to test the service). Is there any way to bypass this error without changing the query?</p>