Grafana 8.3.3 - Timezone difference on 2 different DB sources


I’m having an issue with timescaleDB (postgresql) where all data is ahead 1 hour.
Here’s an image of the same data in influxDB compared to timescaleDB, look specific at the time where it goes down to 0:

openHAB is the system that saves the data (at the same time on both databases). The dataset seems correct, TimescaleDB:

          time            |  value
 2022-02-15 11:00:00.44405  |        0
 2022-02-15 10:43:14.80598  |        0 <- This is @11.43 in grafana for some reason
 2022-02-15 10:34:04.164963 | 1930.138
 2022-02-15 10:21:14.803712 | 1888.581

Same dataset in influxDB:

time                item                  value
 ----                ----                  -----
1644919200727000000 W_VVB_Kj_Teknisk_Gulv 0
1644918194808000000 W_VVB_Kj_Teknisk_Gulv 0   <-- Note: 15 Feb 10:43:14 CET 2022
1644917644166000000 W_VVB_Kj_Teknisk_Gulv 1930.138
1644916874804000000 W_VVB_Kj_Teknisk_Gulv 1888.581

As long as I can understand both db’s has the same timestamp for the same data where 10:43 is the correct timestamp.
In grafana both are set to use browser TZ but makes no difference if I choose my location timezone. I know there are workaround like manipulating the time data but I would rather stay away from “hacks” as they always seem to make trouble in the long run :wink:

I’ve debugged and done some research, could be a bug in openHAB where timestamp is saved differently between the sources. I don’t think this is something related to Grafana :slight_smile: