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.

Sign up for GitHub

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

Jump to bottom

Consider standard timezone and timezone_out arguments to dbConnect() #7

Open
krlmlr opened this issue Dec 30, 2018 · 4 comments
Open

Consider standard timezone and timezone_out arguments to dbConnect() #7

krlmlr opened this issue Dec 30, 2018 · 4 comments
Labels
interface 🔌

Comments

@krlmlr
Copy link
Member

krlmlr commented Dec 30, 2018

r-dbi/RMariaDB#93 (comment)

With tests.
@hannes
Copy link

hannes commented Sep 5, 2019

So the behaviour would be to convert posixct returned by db to this time zone?

@krlmlr
Copy link
Member Author

krlmlr commented Sep 5, 2019

Yes. The other behavior would be to add timezone information to columns that are flagged as "local time", e.g. in MariaDB, so that the time comes out correctly. Also important for datetime -> date coercions.

@krlmlr krlmlr changed the title Consider standard timezone argument to dbConnect() Consider standard timezone and timezone_out arguments to dbConnect() Dec 27, 2020
@krlmlr
Copy link
Member Author

krlmlr commented Oct 17, 2021

In a rewrite.

@krlmlr krlmlr closed this as completed Oct 17, 2021
@krlmlr krlmlr transferred this issue from r-dbi/DBI Oct 31, 2021
@krlmlr krlmlr reopened this Oct 31, 2021
@krlmlr
Copy link
Member Author

krlmlr commented Oct 31, 2021

Time zones can also differ in between columns, we might want to consider specifying the time zone per column.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
interface 🔌
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@hannes @krlmlr