Select * FROM OPENQUERY( LNK_VINS, 'SELECT CAST(EVL(chkdate, NULL) AS date) FROM paytran where !deleted()') order by 1 ------------- Server: Msg 8114, Level 16, State 10, Line 1 Error converting data type DBTYPE_DBDATE to datetime.I serg resolve it but i think it not a good idea. I really what cause the error.
Select * FROM OPENQUERY( LNK_VINS, 'SELECT ALLTRIM(STR(YEAR(chkdate))) + "-" + ALLTRIM(STR(MONTH(chkdate))) +"-" + ALLTRIM(STR(Day(chkdate))) as chkDate FROM paytran where !deleted() ')