|
|
Rank: Newbie
Groups: Member
Joined: 6/23/2010
Posts: 8
|
We have a OLEDB Com Connector querying a SQL database. The database is set-up in UTC time. We are currently in UTC+1 When i query from processbook the timestamp of tags in correct. However when i use datalink with excel 2007 the timestamp is 1 hour out. If a do a 'sampled data' with datalink from 10:00 to 12:00, the timestamp which display are 09:00 to 11:00. Any ideas, thanks.
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 612
Location: Cheshire, United Kingdom.
|
Hello (Congratulations on being our 300th member!), You can check/uncheck "Use PI Server Time Zone" setting in PI-Datalink. Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Newbie
Groups: Member
Joined: 6/23/2010
Posts: 8
|
Hi, Thanks, do i get a prize for being the 300th member  I have changed the time setting to 'PI Server Time' and it makes no difference.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 612
Location: Cheshire, United Kingdom.
|
Hi Mark, You get a beer from me if our paths cross for being the 300th member. What do you have set for time zone in Processbook? (Tools -> Preferences). Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
|
Guest
|
