AnsweredAssumed Answered

How to get top of the hour value when using PI OLEDB Provider and pass through query

Question asked by ggreen on Dec 17, 2014
Latest reply on Jan 7, 2015 by ggreen
Branched from an earlier discussion

I have a related question. I am using PI linked through the OLEDB driver to SQL and passing through queries in PI Syntax. How can one efficiently query the top of the hour value for all points? Can this be queried from one of the "tables" using a timestep of '1h'?

 

Thanks in advance.

Outcomes