Hi, I'm stuck on converting a MySQL date field (on a linked server) to MS SQL datetime format. I've googled this, but am having trouble finding something useful (other than using OpenQuery, but that's not ideal for a large update command with joins between the MySQL and MS SQL tables).
Here's an abbreviated version of my update command:
SET guardian1_attended_date = A_D.guardian1_attended_date
from NCU_Apply_FromWeb NAW
inner join mysql_apply...apply_2 A_D on A_D.uid = NAW.uid
Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.