You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "Alice-608 (via GitHub)" <gi...@apache.org> on 2026/02/26 07:51:26 UTC
[D] Inconsistent datetime offsets in charts on master – anyone seeing this on 6.0.0? [superset]
GitHub user Alice-608 created a discussion: Inconsistent datetime offsets in charts on master – anyone seeing this on 6.0.0?
On latest master, I'm seeing inconsistent datetime offsets in bar/scatter charts (eg: some points shift hours, others days), while raw SQL Lab queries return correct timestamps.
Before rolling back, has anyone experienced this on 6.0.0 with a similar setup (PostgreSQL/MySQL)? Just need to know if this is a master regression or also present in stable. Thanks!
GitHub link: https://github.com/apache/superset/discussions/38265
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Inconsistent datetime offsets in charts on master – anyone seeing this on 6.0.0? [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on the discussion: Inconsistent datetime offsets in charts on master – anyone seeing this on 6.0.0?
<!-- Answer -->
This appears to be a **master-only regression**. There's a [known issue (#37925)](https://github.com/apache/superset/issues/37925) tracking exactly what you're describing—non-uniform datetime shifts in Bar/Scatter charts while SQL Lab returns correct values.
The root cause is that chart queries apply datetime normalization via `normalize_dttm_col()` which SQL Lab bypasses. This normalization can apply up to three offset layers (datasource offset, query time shift, time comparison offsets) conditionally per row, causing the inconsistent shifts you're seeing.
Several related fixes were merged in Feb 2026 on master:
- [PR #37979](https://github.com/apache/superset/pull/37979): Fixed `datetime_to_epoch` to use `astimezone(pytz.utc)` instead of `replace(tzinfo=pytz.utc)`
- [PR #35587](https://github.com/apache/superset/pull/35587): Added `utc=True` to PyArrow datetime conversion
**Temporary workaround**: Try setting the dataset offset to 0 (no offset) if viable for your use case.
Since these fixes landed recently on master and the issue was reported against master, 6.0.0 stable should not have this particular regression. If you're on master, you may want to ensure you have the latest commits including the above fixes.
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*
---
Docs are dead. Just use [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-tagline&utm_term=apache%2Fsuperset).
[](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-feedback&utm_term=apache%2Fsuperset&message_id=4dae40cc-3481-438b-8d90-38b53b192611) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-ask-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-share-team&utm_term=apache%2Fsuperset)
GitHub link: https://github.com/apache/superset/discussions/38265#discussioncomment-15931578
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org