截图字符串SUBSTRIGN

update students set class_date=REPLACE(class_date,class_date,SUBSTRING(class_date,1,14)) where studentId='7383jskddskldkfjsj' and create_date >'2016-09-19';