title: Make mysql convert_tz function work on a H2 database
body: <p>I'm writing a test under an H2 in memory DB that using MySql dialect(<code>org.hibernate.dialect.MySQL5InnoDBDialect</code>), Since we run that one in production.</p>
  <p>On one the repositories we have a custom query with the block:</p>
  <p><code>DATE(CONVERT_TZ(NOW(),'GMT', (:timezoneOffset)))</code></p>
  <p>How ever, H2 throws the following error:</p>
  <p><code>org.h2.jdbc.JdbcSQLSyntaxErrorException: Function &quot;convert_tz&quot; not found;</code></p>
  <p>I tried the solutions suggested in this post:
  <a href="https://stackoverflow.com/questions/31725820/how-to-use-the-mysql-convert-tz-function-in-a-jpql-or-hql-query/31741171">How to use the MySQL CONVERT_TZ function in a JPQL or HQL query</a></p>
  <p>Also tried with a <code>SQLFunctionTemplate</code> like in this examples: <a href="https://www.tabnine.com/code/java/methods/org.hibernate.boot.MetadataBuilder/applySqlFunction" rel="nofollow noreferrer">https://www.tabnine.com/code/java/methods/org.hibernate.boot.MetadataBuilder/applySqlFunction</a></p>
  <p>But I keep getting the exact same error. And don't see any other workaround to make it work. any help would be appreciated.</p>