[GitHub] [superset] rumbin commented on issue #18079: The union of two timestamptz changes the time of the stamps

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

rumbin commented on issue #18079:
URL: https://github.com/apache/superset/issues/18079#issuecomment-1019082226


   What timezone is your Superset installation set to?
   I.e., what is the session timezone of Superset's connection to Postgres?
   
   Not quite sure yet, but I suspect that it has to do with Postgres' timestamptz type which is represented internally as UTC and which only gets translated to/from the session timezone upon querying.
   
   You might want to try a client like DBeaver where you can set the session timezone. Then run the above code while using different timezone settings.
   


-- 
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: notifications-unsubscribe@superset.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org