AnsweredAssumed Answered

How to get UTC data out of OLEDB when on DST

Question asked by stuartstanton-davies on May 17, 2012
Latest reply on Apr 11, 2015 by Namsraijav

We send an SQL query to PI via a linked server using OLEDB.  It returns the time in DST.  We need it in UTC.

 

I know I can create a DST handling procedure, along with DST static data, however that seems unnecessary when PI holds the data time as UTC.

 

Any ideas?

 

 

 

 

Outcomes