[GitHub] [arrow-datafusion] avantgardnerio commented on issue #3148: [EPIC] A collection of Date/Time related open issues

[GitBox <gi...@apache.org>]

avantgardnerio commented on issue #3148:
URL: https://github.com/apache/arrow-datafusion/issues/3148#issuecomment-1226105182

   Proposal:
   
   We attack this in multiple steps parts:
   1. Add `timestamp` but not `timestamp with timezone`
   2. Hard code the server "local" time zone to always be UTC, such that `show time zone` always returns UTC and `set time zone 'UTC'` is the only `set` command that will not produce an error
   3. Add `timestamp with timezone`, but it will always be UTC due to the above
   4. Add support for `set time zone 'UTC+8'`
   5. Add support for `set timezone 'US/Mountain`
   
   I think the above plan will allow us to tackle the problem in stages, without ever technically breaking ANSI compliance and reaching full compliance at the end state. Caveat: I'm not sure if we will ever reach the end state, and I'm okay with that personally.


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org