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

Set default timezone to UTC in importer #194

Closed
morazow opened this issue Mar 17, 2022 · 2 comments · Fixed by #200 or #201
Closed

Set default timezone to UTC in importer #194

morazow opened this issue Mar 17, 2022 · 2 comments · Fixed by #200 or #201
Labels
bug Unwanted / harmful behavior

Comments

@morazow
Copy link
Contributor

morazow commented Mar 17, 2022

Situation

Currently, when importing timestamp values using java.sql.Timestamp, they are converted to the timezone of the database nodes (DBTIMEZONE setting). This leads to the wrong expectations, since Timestamp is always UTC.

Until this this feature is introduced exasol/script-languages-release#539, set the UDF application timezone to UTC using:

TimeZone.setDefault(TimeZone.getTimeZone("UTC"))

Acceptance Criteria

  • UTC timezone is set before emitting
  • Test adapted
@morazow morazow added the bug Unwanted / harmful behavior label Mar 17, 2022
@morazow
Copy link
Contributor Author

morazow commented Mar 18, 2022

Check that EXPORT is also fixed and behaves similarly.

@morazow
Copy link
Contributor Author

morazow commented Mar 18, 2022

As discussed with @allipatev, we should enable this with user parameter first so that users are not faced with sudden behavior change.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Unwanted / harmful behavior
Projects
None yet
1 participant