How to get a time series panel that displays per date only data, with the correct date?

Grafana Dashboards
1

We have a mysql table that has data on a per “date” basis. We want to show this data in grafana as a time series. The issue is that even though the query returns dates like 2026-04-13, the timeseries shows 2026-04-12, because it gets converted to local time. The only way to change that is to make the whole dashboard set to UTC.

How can I have this timeseries work where a mysql date column is always treated as a date?

2

set the whole dashboard set to UTC and then use function like convert_tz to convert your date to UTC. what is the time zone of your date column?