PI OLEDB error

Discussion created by ygalipeau on Nov 26, 2013
Latest reply on Nov 27, 2013 by michaelh

good morning


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?