Grafana adds the timezone difference to dates

user_14157438 0
Viewed 2337

I recently started using Grafana to show data I have in my PostgreSQL Database. Now I've reached a point where when selecting data and using a certain timestamp field as the "time" field in Grafana, the data that's shown is the dates + timezone difference.

For example: My data has the timestamp "2020-08-24 12:05:30" and my timezone is UTC+3, but Grafana shows it as "2020-08-24 15:05:30".

Is there any way to simply display the data as it exists in my DB without adding that timezone difference?

grafana timezone datetime postgresql
2 Answers

Go to the dashboard settings and make sure the timezone is set to UTC or whatever timezone is used by the data.

Grafana dashboard settings

user_1897640

Changing the timezone wasn't my solution, as it would also shift "now". I simply added an interval to my query:

TO_TIMESTAMP(DateTime, 'YY-MM-DD HH24-MI-SS') - interval '2 hour' as time

to shift it 2 hours

user_109284460
Related