AnsweredAssumed Answered

Finding the time for a specific value with PIOLEDB

Question asked by ygalipeau on May 24, 2016
Latest reply on May 24, 2016 by ygalipeau

Good morning,

 

is there a way to get the time for a specific value of a tag.

 

For example, something like this:

 

select * from openquery ([PI], 'select time from piinterp2 where tag = ''sinusoid''

and time between ''2016-05-24 04:55:39'' and ''2016-05-24 05:59:39'' and value = 10.0 order by time ')

 

i know i could get the last archive value before 10 and the first one after 10 and do the calculation myself, but is there a way to query this directly?

Thanks

 

Yannick

Outcomes