AnsweredAssumed Answered


Question asked by Narendra09 on May 9, 2017
Latest reply on May 17, 2017 by rsun

I have added PI server on SQL as Link server. Now i am executing following query


select * from [PISERVER].[PIARCHIVE]..pimax

where time between dateadd(minute,-15,getdate()) and getdate()

and TAG = '%md5.3'


it is working fine but it give value for timestep = 15 minute default.

how to specify filter on timestep ?

I had tried like

1. and timestep = cast('00:10:00' as time)

2. and timestep = '00:10:00'


but it is not working.