Hi!
I'm using H2 and Postgres as data base backends, using the same DDL script to initialize both. With columns of type "TIMESTAMP WITH TIME ZONE", Postgres indeed creates a column of this type. H2, however, doesn't complain and creates a column without a time zone. The column SQLDataType is TIMESTAMPWITHTIMEZONE and I'm using OffsetDateTime as the backing data type. However, this leads to a parse error because apparently, H2 returns an ISO time stamp without a time zone at the end.
Long story short, is it possible to attach a dialect-dependent converter to my column, so I can treat H2 different from Postgres and the others? Or is there an even better solution?
Regards
Philipp