Kunal8954 opened a new pull request, #43807: URL: https://github.com/apache/superset/pull/43807
## Summary Fixes #43801 — dates in table charts showing one day back on systems where the browser can't resolve a valid timezone (e.g. Windows with unrecognized timezone id). ## Root cause `normalizeTimestamp()` only normalized timestamps that included a time component. Bare date-only strings (e.g. `"2023-08-01"`, common for pure DATE columns in Postgres/Greenplum) passed through unchanged and were handed directly to `new Date(...)`. While the ECMA-262 spec says date-only ISO strings should always parse as UTC midnight, some browser/OS combinations parse them as local time instead — shifting the displayed UTC date backward by a day in timezones ahead of UTC. ## Fix Added a `DATE_ONLY_REGEX` branch that normalizes bare date strings to an explicit UTC timestamp (`...T00:00:00Z`), removing the parsing ambiguity regardless of the browser's timezone resolution. ## Testing Added unit tests covering date-only normalization. Verified the regex/Date behavior manually with Node (existing timestamp-with-time cases unaffected). -- 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]
