mysql update设置日期时间格式，字符串转日期

csv数据导入数据库时，日期格式为2022/11/11

由于原数据格式为2022-11-11，运行程序后报错：

com.fasterxml.jackson.databind.exc.InvalidFormatException: Cannot deserialize value of type `java.util.Date` from String "2022/9/2 11:11:12": expected format "yyyy-MM-dd HH:mm:ss"
 at [Source: (ByteArrayInputStream); line: 1, column: 117] (through reference chain: com.insaic.uis.model.newclaim.GpicNonAutoClaimPaymentNoticeMO["paymentDate"])

所以需要把新导入的数据paydate字段全部转成日期类型

---

解决方式：

 select str_to_date(paydate, '%Y/%m/%d') from zj_ltx_sqyk_paylist WHERE datasort ='0'

确定好后，一键更新：

UPDATE zj_ltx_sqyk_paylist set paydate=str_to_date(paydate,'%Y/%m/%d') WHERE datasort 0' ;