1 of 1 people found this helpful
Hello Jean-Francois Dubus,
The PI Data Archive stores all client data in UTC time and uses client timezone context to read the data. As such to view the data without the time offset you would need to be on a client that does not use daylight savings.
Kristian Haner is absolutely right, The PI Data Archive stores all times in UTC seconds and then applies a shift depending on the client settings, either using the PI Data Archive time zone or the client time zone.
I just want to add a few more points here, The OPC interface can also apply an offset to adjust for small amounts of clock drift between the OPC server, PI OPC interface, and PI Data Archive nodes. There are a few different settings for this offset, discussed in detail in KB00305.
I suspect this issue mainly because of Time setting mismatch. You can use pidiag -tz to check the current settings and change the setting based on your timezone in localhost.tz file where the time settings are stored.
Thank you for your replies.
I think I will load summer times data and winter times data separately with an offset of one hour for the winter times. Like this, the timestamps will be good (I will counter PI Server translation of winter times to summer times).
Thank you !