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.