I imagine this is one of those super common sense things that anyone who works with databases knows, but I didn’t. In my database I have a bunch of timestamps – specifically in Postgres I have columns with type
timestamp with time zone. In Grafana, the time column is selected appropriately, and ends up in UTC. I couldn’t figure out a way for Grafana to convert the data (I’d love to hear it if there is). Turns out it’s trivial to edit the query to convert the timestamp. For example:
SELECT created_At AT TIME ZONE 'America/Toronto' AS "time", temperature FROM temperature WHERE $__timeFilter(client_time) ORDER BY 1
No more mental gymnastics while looking at my dashboards! Small quality of life improvement for me, plus learned a little tiny bit.