Hi,
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 
