AnsweredAssumed Answered

PI SQL commander query specific time

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



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,