UPDATE WashDataOfChangLong
SET completedDate = CONVERT(DATETIME, completedTime, 111)
WHERE completedTime IS NOT NULL;
update DeviceInterface set deviceBrand='Steris',deviceModel='changlong' where deviceBrand='ChangLong';