Skip to Content
Former Member
Sep 14, 2011 at 09:23 PM

PCo 2.1 OLEDB against GE Proficy Historian


PCo 2.1.6

MII 12.1.8

GE Proficy Historian 4.0

Hey everyone. I found something interesting with PCo OLEDB against GE Proficy Historian. I haven't tried it against Pi yet to see if I can repeat. All of my queries are coming back with timestamps in GMT. Yes, I tried setting the Variant Representation to "First" and unchecking "Convert Date and Time Values of Server to UTC" Doesn't make a difference. MII knows the timestamp column is a timestamp (it comes back with datatype 93, and MII displays the values in ISO time format.

Historian has its own OLEDB query tool that I ran on the server.

Its rather annoying as I have to go back and adjust all the recordset timestamps local server time using BLS. Has anyone else seen this?