Timezone issue InfluxDB and Grafana

I have influxdb 1.8+ version and Grafana 9.2+ version on Windows machine PC.
Currently the computer is in Timezone GMT+4 and I have customized software that writes data to influxdb server at timestamp equal to the same timezone (GMT+4).
Now everything is working fine when querying data relative to time (last 5min, last 3 hours and etc), I experience some problem when querying last 7 days of data and groupby it on “24h” or “1d”. I found at that it calculates the aggregation based on Day1+4H to Day2+4h, instead of for example Mar 1 00:00:00 to Mar 1 23:59:59, it calculates to Mar 1 04:00:00 Mar 2 03:59:59, so basically it offset to my time region which is I don’t like.

Any idea how can I fix this?


all data grafana uses should be in UTC in the source db. if not you will need to write a function that changes that datetime to UTC

1 Like

Hi @yosiasz thanks for the info.
Does this mean that my computer (where influxdb installed) should be in UTC timezone?
Because current setup is I installed it in machine where timezone is GMT+4. I don’t know if my understanding was right (correct me if I am wrong).
Should my customized software writing data in UTC timestamp? (regardless of my influxdb server timezone?). So in my case, the customized software should writing on -4 hours (UTC time) isn’t it?

Thanks and regards,

Please see my comment carefully

I mention only the db. Either the time on db date column has to be utc when writing to it or use a function that converts current non utc datetime column to utc

Hi @yosiasz apologies for I am literally confused :sweat_smile:.
Assuming the time in my db level is not in UTC (it is on GMT+4 timezone as per my current setup) is there a function in grafana that I can convert the time to UTC?
Should I change the timezone on my grafana to UTC? or should I add TZ(‘UTC’) on my influxdb query, thanks!

Again, All of it in the db. So is there a function in influxdb that changes non utc to utc?

Yes there is…

My grafana’s browser default timezone is in Dubai also (GMT+4).
And check the timestamp returned by grafana is already in GMT+0. I think working now. Thanks!

1 Like

Shukran habibi