sorry i am not sure where i have to post this.. but i also got the same erorr


Error converting data type DBTYPE_DBTIMESTAMP to datetime.

with my sql something like this

select DUE_DATE_END_OPER from openquery
(MARS_PGS, 'select DUE_DATE_END_OPER from PG8_PROD_0_REPORT.F_HVE_APO_ROUTE')

could somebody help me explain?or any solution? as i am not good in sql..
thank you