AnsweredAssumed Answered

PI SQL commander query specific time

Question asked by Sean1991 on Sep 11, 2018
Latest reply on Sep 11, 2018 by jyi

Hi,

 

I need to query data from a specific time of some day to now. For example, I need to query data from 0:00 seven days before to the current time, but the below query only looks back 7x24 hours.

 

WHERE StartTime= '*-7d'  

AND EndTime = '*'

 

Many thanks,

Outcomes