Use ZonedDateTimeJdbcType or OffsetDateTimeJdbcType or LocalTimeJdbcType or OffsetTime or LocalDateTime or LocalDate or Instant instead.
Use ZonedDateTimeJdbcType or OffsetDateTimeJdbcType or LocalTimeJdbcType or OffsetTime or LocalDateTime or LocalDate or Instant instead.
HSQLDB uses a non-standard string representation of timestamps.
HSQLDB uses a non-standard string representation of timestamps. It doesn't pad the hour and offset-hour with zeros. Although the hour can be handled by DateTimeFormatterBuilder, the offset hour can't. See it's method appendOffset() So we handle this in two steps: first pad (trim) zeros in the offset, and then use a custom DateTimeFormatterBuilder.