title: How to add Days to a current Date in h2 database?
body: <p>Query is executing in DB2 DB but its failing in H2 database:</p>
  
  <pre><code>SELECT P.CC_ID, MIN(P.CC_EXP_DT) CC_EXP_DT, MIN(P.PAYMT_TYP_CD) PAYMT_TYP_CD
      FROM Q.PAYMT P
      WHERE (P.PAYMT_BILLSTAT_CD = 'PD'
          OR (P.PAYMT_DUE_DT &lt;= CURRENT DATE + CAST( 10 AS INT ) DAYS
          AND P.PAYMT_BILLSTAT_CD IN ('FB', 'RR', 'RP'))) AND (P.CC_ID IS NOT NULL)
          AND (P.INSTR_TYP_CD = 'EP') AND (P.PAYMT_TYP_CD IN ('VI', 'MC'))
      GROUP BY P.CC_ID
  </code></pre>
  
  <p>Error in H2 DB like :</p>
  
  <blockquote>
    <p>Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Syntax
    error in SQL statement "SELECT P.CC_ID, MIN(P.CC_EXP_DT) CC_EXP_DT,
    MIN(P.PAYMT_TYP_CD) PAYMT_TYP_CD FROM Q.PAYMT P WHERE
    (P.PAYMT_BILLSTAT_CD = 'PD'  OR (P.PAYMT_DUE_DT &lt;= CURRENT DATE +
    CAST( 10 AS INT ) DAYS[*] AND P.PAYMT_BILLSTAT_CD IN ('FB', 'RR',
    'RP'))) AND (P.CC_ID IS NOT NULL) AND (P.INSTR_TYP_CD = 'EP') AND
    (P.PAYMT_TYP_CD IN ('VI', 'MC')) GROUP BY P.CC_ID"; expected "[, ::,
    *, /, %, +, -, ||, ~, !~, NOT, LIKE, ILIKE, REGEXP, IS, IN, BETWEEN, AND, OR, ,, )"; SQL statement:</p>
  </blockquote>
  
  <p>here DAYS[*] function in not available in H2 DB, please help me to execute above query</p>