Niivii commented on issue #2843: URL: https://github.com/apache/arrow-adbc/issues/2843#issuecomment-3311455511
Hello @zeroshade, Coming back to you on this one. `TIMESTAMP_TZ` stores the original time zone information along with the timestamp, whereas `TIMESTAMP_LTZ` assumes that all timestamps are in a local (session) time zone and does not store any time zone information. Referring to your table, this is imho an issue that `TIMESTAMP_LTZ` is being used. It should be `TIMESTAMP_TZ` to preserve the time zone context, especially when dealing with data generated from different time zones. I end up with exactly the same output (or display) of my data whether I'm using `TIMESTAMP_LTZ` or `TIMESTAMP_TZ` and my offsets are not preserved at the moment. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
