plcforum.uz.ua

International PLC Forum
It is currently Sat Apr 21, 2018 11:47 pm

All times are UTC + 3 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Wed Dec 20, 2017 10:12 am 

Joined: Tue Dec 20, 2011 9:07 am
Posts: 3
IN WONDERWARE INSQL, take a query and return a result table. use intouch ,I can query the results from historian db, but can't get the period between 2 rows.
ie
result table ,5 rows ,

datetime tagname value
2017-12-10 10:22:10 production 2.0
2017-12-12 17:11:17 production 3.2
2017-12-14 10:35:20 production 4.2
2017-12-15 18:00:00 production 4.2
2017-12-17 22:00:00 production 19.6

how to get the length of time that one prodution value lasting? (sos) (sos) (sos)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC + 3 hours


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by International PLCforum® Forum Software © PLCforum
Mobile version