When selecting and displaying data from a DB query on time, despite the fact that I have a group by day, still it always shows the time as 2AM instead of 12:00am. is there a way to change the time to 00:00?
If you show a graph does it show the correct times on the graph? If not the you have a time zone issue.
How to I fix the time zone?
All timestamps in the backend database which Grafana reads must be in UTC.