Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Find way to address (or at minimum document) time abberation for TIME WITH TZ literals with zones [JDBC622] #652

Closed
firebird-automations opened this issue May 15, 2020 · 4 comments

Comments

@firebird-automations
Copy link

Submitted by: @mrotteveel

Jira_subtask_outward JDBC629
Jira_subtask_outward JDBC630

Just before the Firebird 4 beta 2 release, the decision was made to base the UTC derivation for TIME WITH TZ literals with a named zone on 2020-01-01 instead of the current date. This causes off-by-one-hour issues with the logic in Jaybird to use the current-date for determining the offset for the named zone.

As an example, selecting time'13:25:32.1235 Europe/Amsterdam' on the 15th of May will now yield an offset time 14:25:32.123500+02:00 instead of either 13:25:32.123500+02:00 (older snapshots of Firebird 4), or 13:25:32.123500+01:00 (which would be inline with what Firebird derives).

Find a way to address this, or at least add a caution to the documentation.

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Using 2020-01-01 as base date for offset derivation might be the best and most compatible option, however I have also raised a discussion on firebird-devel if we really want this.

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Fix Version: Jaybird 4.0.1 [ 10921 ]

Fix Version: Jaybird 5 [ 10871 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment