avantgardnerio opened a new issue, #3255: URL: https://github.com/apache/arrow-datafusion/issues/3255
**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** Presently, `show timezone` does not work: ``` DataFusion CLI v11.0.0 ❯ show time zone; NotImplemented(“SHOW time.zone not implemented. Supported syntax: SHOW <TABLES>“) ``` **Describe the solution you'd like** Instead, I would like: ``` show timezone; ``` To always return 'utc'. ``` set timezone 'utc'; ``` Should succeed. ``` set timezone 'UTC+08`; ``` should return an error. and ``` set timezone 'US/Mountain`; ``` should return the same error. This should: 1. make the work @waitingkuo is doing easier by ignoring non-UTC zones for now 2. Stay technically compatible with ANSI SQL & postgres (as long as postgres is set to UTC) 3. allow the option to implement timezones at a future date. **Describe alternatives you've considered** - Having to violate ANSI SQL - Having to tackle timezones while implementing `timestamp without timezone` -- 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]
