We encounter a problem on datetime return when using PCo 2.2 and PIOLEDB to query the PI Historian.
The issue is when we use a select statement to get the history data for the past hour from piarchive..picomp, the datetime column is exactly 5 hours different than what we can see from PI SMT. The historian, MII server and client machine is all in Central time zone. Hence there should not be any difference.
We have used PIOLEDB tester to run the same query and the returned datetime is correct. We also tried to change the time zone value in the connection string All tab from local to server but it didn't change the result. Looks like it's a problem on PCo or the MII side.
Any idea on what's causing this problem? Thanks for your help and suggestions in advanced.