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.
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.