title: H2 org.h2.jdbc.JdbcSQLSyntaxErrorException when inserting a Timestamp
body: <p>A SQL query comparing timestamps works in MySQL, but fails when using an H2 database.</p>
  
  <p>As an example, this is the query that produces the exception:</p>
  
  <p><code>SELECT * FROM table WHERE time &gt;= '2019-02-01T10:59:12.632Z' AND time &lt;= '2019-04-12T10:59:12.632Z'</code></p>
  
  <p>The query is created dynamically using Java code, and the timestamps above are of type <code>java.time.Instant</code>.</p>
  
  <p>I have even tried using other types of date/time objects, with the same outcome. </p>
  
  <p>This query executes fine using MySQL, but throws the following error using an H2 DB:</p>
  
  <pre><code> org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement 
   "SELECT * FROM table WHERE  time&gt;= 2019-04-10T13[*]:31:19.498Z AND  time &lt;= 2019-04-07T13:31:19.498Z";
   SQL statement: 
   SELECT * FROM table WHERE  time &gt;= 2019-04-10T13:31:19.498Z AND  time&lt;= 2019-04-07T13:31:19.498Z
  </code></pre>
  
  <p>I find it puzzling that using colon-separated timestamps cause this issue, especially since the <a href="http://www.h2database.com/html/grammar.html?highlight=delimiter&amp;search=delimiter#timestamp" rel="nofollow noreferrer">H2 docs use similar timestamps</a></p>