search

r-dbi / dbi3

DBI revisited
https://r-dbi.github.io/dbi3
37 stars 2 forks source link

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

Open krlmlr opened 5 years ago

krlmlr commented 5 years ago

https://github.com/r-dbi/RMariaDB/issues/93#issuecomment-405058247

With tests.

hannes commented 5 years ago

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

krlmlr commented 5 years ago

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 commented 2 years ago

In a rewrite.

krlmlr commented 2 years ago

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