You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/01/04 17:45:32 UTC
[GitHub] [incubator-superset] gogitub opened a new issue #12256: Need to show timestamp with time zone field in a different time zone in the report
gogitub opened a new issue #12256:
URL: https://github.com/apache/incubator-superset/issues/12256
Hi,
We have many timestamp with time zone fields in Oracle database which is the source for our Superset (0.36 version) reports.
We need to show the data in EST or PST or some other time zones based on customer need.
Ex:
Data in Oracle database table is like '2021-01-04 21:48:56.66 +05:30'
If we want to display in EST, report should show it like : 2021-01-04T11:18:56.660000
If we want to display in PST, report should show it like : 2021-01-04T08:18:56.660000
So, is there any configuration parameter that we can modify to display the data in desired time zone (like EST/PST or some other)?
Please advise. Thanks in advance.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] gogitub commented on issue #12256: Need to show timestamp with time zone field in a different time zone in the report
Posted by GitBox <gi...@apache.org>.
gogitub commented on issue #12256:
URL: https://github.com/apache/incubator-superset/issues/12256#issuecomment-754456189
@zhaoyongjie, Thank you for your interest in answering my question.
There are a lot of such fields and many time zones are available in the data. we are not preferring any derived columns because we already have lot many reports/dashboards built with the existing columns.
Also, we need to show the data displayed in time zone per user profile or preference if there is a way.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] zhaoyongjie edited a comment on issue #12256: Need to show timestamp with time zone field in a different time zone in the report
Posted by GitBox <gi...@apache.org>.
zhaoyongjie edited a comment on issue #12256:
URL: https://github.com/apache/incubator-superset/issues/12256#issuecomment-754427413
@gogitub. Is it possible to add derived dimensions from the original date field ?
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] zhaoyongjie commented on issue #12256: Need to show timestamp with time zone field in a different time zone in the report
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #12256:
URL: https://github.com/apache/incubator-superset/issues/12256#issuecomment-754427413
@gogitub. Is it possible to add derived dimensions from the original date field
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] gogitub commented on issue #12256: Need to show timestamp with time zone field in a different time zone in the report
Posted by GitBox <gi...@apache.org>.
gogitub commented on issue #12256:
URL: https://github.com/apache/incubator-superset/issues/12256#issuecomment-754779879
It is observed that Superset is automatically converting the timestamp fields to EST time while displaying in the SQL Lab or Chart.
Anyone knows where exactly we can change this setting to show it in different time zone or customize it to work using a config parameter?
----------------------------------------------------------------
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.
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