AnsweredAssumed Answered

PI OLEDB SQL

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.

Outcomes