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/03/14 12:19:19 UTC
[GitHub] [incubator-superset] FU100 opened a new issue #9304: Timezone
offset doesn't work?
FU100 opened a new issue #9304: Timezone offset doesn't work?
URL: https://github.com/apache/incubator-superset/issues/9304
Version: 0.999.0dev
### Expected results
__time = 2020-03-04T10:00:00.000Z
### Actual results
__time = 2020-03-04T02:00:00.000Z
#### How to reproduce the bug
1. in druid
__time:2020-03-04T02:00:00.000Z
2. /usr/local/src/incubator-superset# docker exec -it ef023b203bb9 /bin/bash
3. superset@ef023b203bb9:/app$ date -R
Sat, 14 Mar 2020 19:18:48 +0800
superset@ef023b203bb9:/app/superset$ cat config.py | grep DRUID_TZ
#DRUID_TZ = tz.tzutc()
DRUID_TZ = tz.gettz('Asia/Shanghai')
4. in superset
Go to Sources->Tables->Edit Table
Offset:8
Run Query
__time = 2020-03-04T02:00:00.000Z
but not 2020-03-04T10:00:00.000Z
### Environment
(please complete the following information):
- superset version: ` 0.999.0dev`
- python version: `3.6.9`
- node.js version: `node -v`
- npm version: `npm -v`
----------------------------------------------------------------
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] FU100 closed issue #9304: Timezone config
doesn't work?
Posted by GitBox <gi...@apache.org>.
FU100 closed issue #9304: Timezone config doesn't work?
URL: https://github.com/apache/incubator-superset/issues/9304
----------------------------------------------------------------
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] ktmud commented on issue #9304: Timezone
config doesn't work?
Posted by GitBox <gi...@apache.org>.
ktmud commented on issue #9304: Timezone config doesn't work?
URL: https://github.com/apache/incubator-superset/issues/9304#issuecomment-609524741
"Z" in the timestamp actually means UTC time (+00:00), so whatever time zone you set, as long as the data type is timestamp, it will always return in UTC time. You can probably create a calculated column with time offset instead.
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org