i am doing some pi extractions via a SQL linked server. I am using sql 2012 and pilodb 2010 R3. my query is the following
select * from openquery(ITSQL2012_PI,'select *
from piinterp where tag = ''park.windspeed''
and Time >= ''2013-09-01'' and Time <= ''2013-09-30''
AND Timestep =''12h''')
everything is fine. if i change the 12h to 24h i receive the following error
Error converting data type DBTYPE_DBTIME to time. same thing if i try to use 1d
any idea why that is happening?