title: How to convert db2 date format to H2 date format for in memory testing in java
body: <p>I am trying to convert the DB2 data base Date field format into H2 in memory database date format as shown below. It did not work for me. 
  Please help.</p>
  
  <pre><code>select CREATE_DATE from PX.MY_DB2TABLE ;
  </code></pre>
  
  <p>Here DB2 DATE format in database table is 'MM/DD/YYYY'.  CREATE_DATE is DATE data type in db2.</p>
  
  <p>H2 database is accepting only 'yyyy-MM-dd' format.</p>
  
  <p>Tried the following way in H2:</p>
  
  <pre><code>  select PARSEDATETIME(CREATE_DATE,'MM/dd/yyyy') FROM PX.MY_DB2TABLE;
      select PARSEDATETIME(CREATE_DATE,'yyyy-MM-dd') FROM PX.MY_DB2TABLE;
  </code></pre>
  
  <p>Error:
  Cannot parse DATE constant</p>