avantgardnerio commented on issue #4106:
URL:
https://github.com/apache/arrow-datafusion/issues/4106#issuecomment-1303856668
@waitingkuo thank you for your clear communication as always! You have the
most reviewable PRs and issues I've seen :smile: .
The issue looks good to me, but I would propose tackling in stages:
1. Allow things like `set time zone to '+08:00';` as described
2. Allow `set time zone to 'US/Mountain';` or `set time zone to
'US/Denver';` or ``set time zone to 'MT';`
This is due to the extra complication of what to do when someone does a
`select TO_TIMESTAMP('2022-11-06T01:30:00');` and the server timezone is
'US/Mountain' and there are two distinct 1:30AMs one in MDT and one in MST. Do
we know what postgres does here? The only sensible thing I can think to do is
fail the query with an error.
--
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]
