how can i get the time when two tag value specified (e.g. one tag 'digital1' value '0' and the other tag 'digital2' value '1') by using sql sentences? thanks a lot.
and i am wondering how can i get a timestamp when a tag value reaches a line(eg. all the timestamps this week when tag 'cdt158' go up above 100 and timestamps when tag 'cdt158' go down below 100) by using sql sentences.
now i can only use 'select timeq ' like "select timeeq('pump1runing','*-7d','*','open') as result" to get the timespan.
thanks a lot again.