You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "SukiSeven (via GitHub)" <gi...@apache.org> on 2025/12/08 02:39:50 UTC
[D] Time Range Filters Are 1 Hour Behind CST (Asia/Shanghai) [superset]
GitHub user SukiSeven created a discussion: Time Range Filters Are 1 Hour Behind CST (Asia/Shanghai)
My server timezone is CST (Asia/Shanghai).
However, the time range Filters in Superset are always 1 hour behind Chinese local time.
**Example**
Current time (server):
**2025-12-08 07:00 CST (Asia/Shanghai)**
When I use a filter such as “**Last Week**”, Superset generates this range:
2025-11-30 <= Filters field < 2025-12-07
But according to local time, it should already be:
2025-12-01 <= Filters field < 2025-12-08
Superset will not switch to the correct range until 08:00 CST.
So the Filters seem to be calculated using UTC+7 instead of UTC+8, or there is a timezone offset of 1 hour somewhere in the calculation.
Expected Behavior
Time range filters (such as Last Week / Last Day / This Week / Today) should follow the server’s CST timezone (UTC+8) and update ranges correctly at 07:00 CST, not 08:00.
Actual Behavior
Filter ranges update one hour late compared to local CST time.
superset Version: 4.0.1
GitHub link: https://github.com/apache/superset/discussions/36449
----
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] Time Range Filters Are 1 Hour Behind CST (Asia/Shanghai) [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] added a comment to the discussion: Time Range Filters Are 1 Hour Behind CST (Asia/Shanghai)
<!-- Answer -->
This is a known limitation in Superset: time range filters like “Last Week” are always calculated in UTC, not in your server’s local timezone. That’s why you see a 1-hour offset in Asia/Shanghai (UTC+8)—the filters update based on UTC midnight, not local midnight, so the range appears “late” by your local time. There’s currently no built-in way to make these filters follow the server’s timezone or a user’s local timezone in version 4.0.1.
The only reliable workaround is to use manual date selection in the filter, rather than relative options like “Last Week” or “Today” [source](https://github.com/apache/superset/issues/35422). The “Hours Offset” feature in the Edit Dataset modal can shift timestamps, but it doesn’t fix this for all use cases and doesn’t affect the filter logic itself.
There’s an active proposal (SIP-186) and ongoing work to add a user timezone selector, which would allow time range filters to honor the user’s selected timezone and display correct date ranges [source](https://github.com/apache/superset/issues/35422). For now, this is a known limitation and area of active development.
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
---
<sup>How did I do? [Good](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=other)</sup>
[](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=This%20is%20a%20known%20limitation%20in%20Superset%3A%20time%20range%20filters%20like%20%E2%80%9CLast%20Week%E2%80%9D%20are%20always%20calculated%20in%20UTC%2C%20not%20in%20your%20server%E2%80%99s%20local%20timezone.%20That%E2%80%99s%20why%20you%20see%20a%201-hour%20offset%20in%20Asia/Shanghai%20%28UTC%2B8%29%E2%80%94the%20filters%20update%20based%20on%20UTC%20midnight%2C%20not%20local%20midnight%2C%20so%20the%20range%20appears%20%E2%80%9Clate%E2%80%9D%20by%20your%20local%20time.%20There%E2%80%99s%20currently%20no%20built-in%20way%20to%20make%20these%20filters%20follow%20the%20server%E2%80%99s%20timezone%20or%20a%20user%E2%80%99s%20local%20timezone%20in%20version%204.0.1.%20%0A%0AThe%20only%20reliable%20workaround%20is%20to%20use%20manual%20date%20sel
ection%20in%20the%20filter%2C%20rather%20than%20relative%20options%20like%20%E2%80%9CLast%20Week%E2%80%9D%20or%20%E2%80%9CToday%E2%80%9D%20%5Bsource%5D%28https%3A//github.com/apache/superset/issues/35422%29.%20The%20%E2%80%9CHours%20Offset%E2%80%9D%20feature%20in%20the%20Edit%20Dataset%20modal%20can%20shift%20timestamps%2C%20but%20it%20doesn%E2%80%99t%20fix%20this%20for%20all%20use%20cases%20and%20doesn%E2%80%99t%20affect%20the%20filter%20logic%20itself.%0A%0AThere%E2%80%99s%20an%20active%20proposal%20%28SIP-186%29%20and%20ongoing%20work%20to%20add%20a%20user%20timezone%20selector%2C%20which%20would%20allow%20time%20range%20filters%20to%20honor%20the%20user%E2%80%99s%20selected%20timezone%20and%20display%20correct%20date%20ranges%20%5Bsource%5D%28https%3A//github.com/apache/superset/issues/35422%29.%20For%20now%2C%20this%20is%20a%20known%20limitation%20and%20area%20of%20active%20development.) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/36449)
GitHub link: https://github.com/apache/superset/discussions/36449#discussioncomment-15190842
----
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] Time Range Filters Are 1 Hour Behind CST (Asia/Shanghai) [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on the discussion: Time Range Filters Are 1 Hour Behind CST (Asia/Shanghai)
<!-- Answer -->
This is a known limitation in Superset: time range filters like “Last Week” are always calculated in UTC, not in your server’s local timezone. That’s why you see a 1-hour offset in Asia/Shanghai (UTC+8)—the filters update based on UTC midnight, not local midnight, so the range appears “late” by your local time. There’s currently no built-in way to make these filters follow the server’s timezone or a user’s local timezone in version 4.0.1.
The only reliable workaround is to use manual date selection in the filter, rather than relative options like “Last Week” or “Today” [source](https://github.com/apache/superset/issues/35422). The “Hours Offset” feature in the Edit Dataset modal can shift timestamps, but it doesn’t fix this for all use cases and doesn’t affect the filter logic itself.
There’s an active proposal (SIP-186) and ongoing work to add a user timezone selector, which would allow time range filters to honor the user’s selected timezone and display correct date ranges [source](https://github.com/apache/superset/issues/35422). For now, this is a known limitation and area of active development.
<!-- 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=2182c402-78d8-4b41-8e6a-0b2e4cc772f1) [](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/36449#discussioncomment-15190842
----
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