Relican opened a new issue, #43801: URL: https://github.com/apache/superset/issues/43801
### 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. But we are facing migration of hundreds datasets and this is 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 <img width="479" height="516" alt="Image" src="https://github.com/user-attachments/assets/64b5ec92-a89e-40b4-af33-db0ada621dcb"; /> <img width="1279" height="786" alt="Image" src="https://github.com/user-attachments/assets/f32e1724-0bb8-40dd-a85b-8c15bc43a3f7"; /> ### 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. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
