PCo 2.2 PIOLEDB system source datetime problem

[Former Member]

Hi experts,

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.

Best regards,
Lawrence

[Former Member · Accepted solution]

Hi Lawrence,

I had same problem, but resolved it by doing this:

In the OleDb database connection, click the "Configure String String" button. On the "All" tab of the DataLink properties dialogue, Scroll down to "TimeZone" setting, "Click Edit Value..." button then enter UTC as the property value.

kind regards,
Dave

[Former Member · Accepted solution]

David,

You advice fixed the issue. Thank you very much!

Best regards,

Lawrence