I assume this is Microsoft SQLserver (style 120 being yyyy-mm-dd hh:mi:ss 24h) and the error message is for some SQL without convert. The SQL shown works for me but do you really want to update all the records in the table with the same values ?.