Philippe Marschall

I do not have a working example with Spring Boot. The only working example I have is with "vanilla" Spring ORM and [persistence.xml](https://github.com/marschall/threeten-jpa/blob/master/threeten-jpa-jdbc42-hibernate/src/test/resources/META-INF/persistence.xml#L38) where I explicitly set the hibernate dialect....

This is not an issue with the `UserType`s in this project or Spring Boot support but with Hibernate not supporting `TIMESTAMP WITH TIME ZONE` for schema generation. If you have...

A quick work around would be to use ```java @Column(columnDefinition = "TIMESTAMP WITH TIME ZONE") @Type(type = Jdbc42OffsetDateTimeType.NAME) private OffsetDateTime recommendedAt; ```

Bug and PR https://hibernate.atlassian.net/browse/HHH-11773 https://github.com/hibernate/hibernate-orm/pull/1916

How many columns are we talking about? If it's several columns you could also create your own dialect like this ```java public class PatchedPostgreSQL95Dialect extends PostgreSQL95Dialect { public PatchedPostgreSQL95Dialect() {...

See https://github.com/microsoft/mssql-jdbc/issues/1182

It's unclear what the JDBC type should be.

@Ramblurr `Duration` support for PostgreS is something I'd like to do. Yes mapping nanos to `BIGINT` would be possible but I feel it's too semantically empty so this is not...

HSQLDB 2.4.0 does support `INTERVAL` and `Duration` and `Period` as well http://hsqldb.org/doc/guide/sqlgeneral-chapt.html#sgc_interval_typs

So does H2 https://github.com/h2database/h2database/pull/1373