plcforum.uz.ua
http://plcforum.uz.ua/

how to get the period BTWN 2 records ?
http://plcforum.uz.ua/viewtopic.php?f=14&t=25721
Page 1 of 1

Author:  liujlshk [ Wed Dec 20, 2017 10:12 am ]
Post subject:  how to get the period BTWN 2 records ?

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)

Page 1 of 1 All times are UTC + 3 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/