title: How to fix Cannot parse "DATE" constant issue in H2 Database?
body: <p>I am porting my Java application which was developed for Windows to AIX Unix. On Windows it uses SQL Server for configuration. On AIX we are trying to use H2 database. Most of the code works but I am getting following error when executing query which has a datetime criteria. </p>
  
  <blockquote>
  <pre><code>org.h2.jdbc.JdbcSQLDataException: Cannot parse "DATE" constant "26-Jun-2019"; SQL statement:
  SELECT EM_SCHEDULER_DAILY_POLL.* FROM EM_SCHEDULER_DAILY_POLL, EM_CONTROLLER WHERE EM_SCHEDULER_DAILY_POLL.CONTROLLER_ID =
  EM_CONTROLLER.CONTROLLER_ID AND EM_SCHEDULER_DAILY_POLL.DATE_TIME
  BETWEEN '26-Jun-2019' AND '26-Jun-2019 23:59:59' AND
  POLLED_SUCCESSFULLY=0 AND EM_SCHEDULER_DAILY_POLL.CONTROLLER_ID=30
  [22007-199]
  </code></pre>
  </blockquote>
  
  <p>This SQL works perfectly on SQL server but gives above exception on H2DB. How to solve this issue? I need both date and time in query.</p>