On 05-03-2020 17:14, Adriano dos Santos Fernandes wrote:
Mark, I hope you never release a Jaybird version that converts named regions to offsets in Java, because if you do you misunderstood the thing completely and Jaybird users will need to have a very wrong behavior forever.
Jaybird will convert regions to offsets in Java. The JDBC specification doesn't support named time zones, only offset time zones (OffsetDateTime/OffsetTime), so I must convert to an offset-based data type.
This is a choice between failing due to an unsupported format (no named zone support), falling back to UTC for all named zones, or to convert to the appropriate offset for the named zone on that date (or on the current date for a TIME WITH TIME ZONE) using Java's time zone information.
Please enlighten me in what way will I have "misunderstood the thing completely", and will "Jaybird users [..] have a very wrong behavior forever"?
Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel