TIMESTAMP WITH TIME ZONE is fully supported only since H2 1.4.197. Such query runs in this version without any problems.
In older versions this data type was experimental and was not supported by many date and time functions. 1.4.196 and older versions throw UnsupportedOperationException on such query. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.