ygalipeau

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?

 

thanks

 

yannick

Outcomes