apache / apache/superset

One day back offset for each date

Open
#43,801 2 comments 0 reactions 0 assignees View on GitHub
#bug
Dominant language
Python
Stars
74.8k
Forks
18.3k
Avg merge
2d 5h
Merged PRs (30d)
685

Description

### Bug description

The bug is frontend-implemented offset for date from database:
When selecting via SQL Lab, dates are from 1st to 31st august.
When creating table chart - dates are from 31st July to 30th August.
This is happening only while rendering chart, due to broken timezone qualification in Windows.
How to reproduce:
1. Check if your windows timezone is TIME_ZONE_ID_UNKNOWN via powershell command "w32tm /tz"
2. Create any dataset (greenplum/postgresql verified by now) with date
3. Create table chart with that date - see that dates have changed
4. go to F12 - three dots - more tools - sensors - TZ override - see that dates became correct

Workaround is to setup "hours offset" in dataset properties to 3 hours.
Another workaround is to remove checkbox "is temporal" from date column in dataset.
But we are facing migration of hundreds datasets and these are not automatized productive solution.

I have found almost relevant issue fixed in https://github.com/apache/superset/pull/42329 but it is backend props and I have no qualification to confirm it would help my frontend.

### Screenshots/recordings

Image
Image

### Superset version

6.1.0

### Python version

Not applicable

### Node version

I don't know

### Browser

Chrome

### Additional context

_No response_

### Checklist

- [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the date shift through SQL Lab and a table chart on the reported Windows timezone, then compare the frontend chart rendering with the backend changes in PR 42329. Done means dates remain unchanged in the chart without dataset hour offsets or disabling the temporal-column setting.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, sql
Domain
data-visualization, frontend
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.