Graph Time Interval

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.

Antony.