Skip to Content
0
Former Member
Nov 09, 2012 at 04:36 PM

PCO 2.2 TimeZone Issue

75 Views

Greetings All,

I have a PCO Connection to a ODBC Datasource mapped to a IP21 data source.

The IP21 data source is set to CST(GMT-5).

I'm trying to validate for our transtion from 11.5 UDS to 12.2 PCo. So I run the same query against the same datasource on both systems.

The data I get back from 11.5 is correctly dated:

DATETIME NAME QUALITY VALUE AgeMn

11/09/2012 10:23:13 Tag1 -1.00 6.67 0.00

11/09/2012 10:22:43 Tag2 -1.00 0.00 0.00

11/09/2012 10:22:43 Tag3 -6.00 0.00 0.00

The data I get back from 12.2 is not correctly dated:

DATETIME NAME QUALITY VALUE AgeMn

11/09/2012 05:24:33 Tag1 -1.00 6.67 0.00

11/09/2012 05:24:23 Tag2 -1.00 0.00 0.00

11/09/2012 05:23:13 Tag3 -6.00 0.00 0.00

Something in the process seems to be assuming the data from the IP21 server is GMT and needs to be adjusted to CST(GMT-5)

I've tryed adjusting the Checkbox in PCo to multiple checked/unchecked for the "Convert Server Date and Time to UTC".

No Good.

Any thoughts would be appreciated.

Thank You in Advance,

Dennis W