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

Wrong default timezoneId for timestamps with no timezoneid #27

Open
marcosapmf opened this issue Mar 9, 2023 · 0 comments
Open

Wrong default timezoneId for timestamps with no timezoneid #27

marcosapmf opened this issue Mar 9, 2023 · 0 comments

Comments

@marcosapmf
Copy link

marcosapmf commented Mar 9, 2023

Hi!
When I try to execute a SELECT query with a timestamp with no time zone id, it returns a different timestamp. For intance:
SELECT TIMESTAMP '2019-02-11 20:26:53.218'; returns 2019-02-12 04:26:53.218+00 as result.

This happens because of the default time zone id google sets is America/Los_Angeles (GMT-8) (see google/zetasql#133). However, the default timezoneid can be set but set_default_timezone_id is not wrapped to be called on Go side.

@marcosapmf marcosapmf changed the title Wrong Default TimezoneId when selecting for a timezone without timezoneId Wrong default timezoneId for timestamps with no timezoneid Mar 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant