jayakarkatika opened a new pull request, #37014:
URL: https://github.com/apache/superset/pull/37014
# fix(dashboard): Apply timezone offset to convert local time boundaries to
UTC
### SUMMARY
Apply timezone offset to convert local time boundaries to UTC
The offset is in hours (e.g., 6 for UTC+6)
If offset is set, we subtract it from the datetime to convert to UTC
Example: User selects "Last day" which gives midnight local time
If offset=6 (UTC+6), we subtract 6 hours to get UTC time
### TESTING INSTRUCTIONS
Set offset hours to 6 in dataset -> edit -> settings
then go to dashboard and select time range: last day
check the network tab.
/data should show query as:
WHERE last_modified >= STR_TO_DATE('2026-01-08 18:00:00.000000',
'%Y-%m-%d %H:%i:%s.%f') AND last_modified < STR_TO_DATE('2026-01-09
18:00:00.000000', '%Y-%m-%d %H:%i:%s.%f') GROUP BY
--
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]
