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?