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 2020/04/02 08:40:35 UTC
[GitHub] [incubator-superset] jayhjha opened a new issue #9449: Timestamps
are only displayed in UTC and not in local timezone
jayhjha opened a new issue #9449: Timestamps are only displayed in UTC and not in local timezone
URL: https://github.com/apache/incubator-superset/issues/9449
All timestamps are only displayed in UTC and not in the local timezone.
I found this issue from 2 years ago regarding this, but there was no resolution: https://github.com/apache/incubator-superset/issues/3928
Ideally, this should be configurable to allow users to select their timezone.
Are there any plans to support this?
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] poleft commented on issue #9449: Timestamps are only displayed in UTC and not in local timezone
Posted by GitBox <gi...@apache.org>.
poleft commented on issue #9449:
URL: https://github.com/apache/superset/issues/9449#issuecomment-791213527
> [#9304 (comment)](https://github.com/apache/superset/issues/9304#issuecomment-609524741)
>
> > There are significant complexity revolving timezone configs. Superset decided to always UTC time to keep things simple. It'd be quite some work if we want to add custom timezone support.
I found that this problem only occurs when using clickhouse, superset will visual local time when the datasource is mysql. I guess whether there are some bugs when connecting clickhouse
----------------------------------------------------------------
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] [superset] krsnik93 commented on issue #9449: Timestamps are only displayed in UTC and not in local timezone
Posted by GitBox <gi...@apache.org>.
krsnik93 commented on issue #9449:
URL: https://github.com/apache/superset/issues/9449#issuecomment-961011118
Seeing the same even without clickhouse. Using a postgresql database and while the field dtype is a `timestamp with time zone` and looks that way in the SQL Lab, when displayed on a chart, the timezone offset is just thrown away.
--
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
[GitHub] [incubator-superset] jayhjha commented on issue #9449: Timestamps
are only displayed in UTC and not in local timezone
Posted by GitBox <gi...@apache.org>.
jayhjha commented on issue #9449: Timestamps are only displayed in UTC and not in local timezone
URL: https://github.com/apache/incubator-superset/issues/9449#issuecomment-611337622
@eugeniamz Thanks for getting back to me.
My DB is in UTC as well and this is the result of my query:
<img width="310" alt="Screen Shot 2020-04-08 at 10 30 50 PM" src="https://user-images.githubusercontent.com/49882088/78861112-d15b0c00-79e8-11ea-8e37-1fa6c57189f4.png">
And the exact same query when run in SQL Lab (I am in PST)
<img width="268" alt="Screen Shot 2020-04-08 at 10 31 32 PM" src="https://user-images.githubusercontent.com/49882088/78861145-eafc5380-79e8-11ea-8672-9c96748abd9b.png">
Did you have to SET the timezone first to get the correct results? Or do anything else?
I'm using Superset 0.35.1.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] eugeniamz commented on issue #9449: Timestamps
are only displayed in UTC and not in local timezone
Posted by GitBox <gi...@apache.org>.
eugeniamz commented on issue #9449: Timestamps are only displayed in UTC and not in local timezone
URL: https://github.com/apache/incubator-superset/issues/9449#issuecomment-611232567
I can't reproduce it. I did this simple test.
My Database is in UTC :
But when query in Superset, I am in EST,
Seems that it shows accordingly. Can you please show an example to reproduce?
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] mkdym commented on issue #9449: Timestamps are only displayed in UTC and not in local timezone
Posted by GitBox <gi...@apache.org>.
mkdym commented on issue #9449:
URL: https://github.com/apache/incubator-superset/issues/9449#issuecomment-658532105
https://github.com/apache/incubator-superset/issues/9304#issuecomment-609524741
>There are significant complexity revolving timezone configs. Superset decided to always UTC time to keep things simple. It'd be quite some work if we want to add custom timezone support.
----------------------------------------------------------------
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] stale[bot] closed issue #9449: Timestamps are only displayed in UTC and not in local timezone
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #9449:
URL: https://github.com/apache/incubator-superset/issues/9449
----------------------------------------------------------------
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] mkdym commented on issue #9449: Timestamps are only displayed in UTC and not in local timezone
Posted by GitBox <gi...@apache.org>.
mkdym commented on issue #9449:
URL: https://github.com/apache/incubator-superset/issues/9449#issuecomment-658529149
Same issue.
I'm using clickhouse and superset.
Datetime data is converted to utc timezone, I'm confused.
I have changed the superset host and container timezone to db's timezone(Asia/Shanghai).
Tried https://pypi.org/project/sqlalchemy-clickhouse-timezone/ , but no sense.
I'm using amancevice/superset:0.36.0 docker image.
----------------------------------------------------------------
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] stale[bot] commented on issue #9449: Timestamps are only displayed in UTC and not in local timezone
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9449:
URL: https://github.com/apache/incubator-superset/issues/9449#issuecomment-640381110
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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