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?