mysql12小时时间格式字符串转24小时格式

查询：

SELECT date,DATE_FORMAT(STR_TO_DATE(date,"%c/%e/%Y %r"),"%Y/%m/%d %H:%i:%s") FROM receiverlog WHERE date LIKE "%M"

更新：

UPDATE receiverlog SET date=DATE_FORMAT(STR_TO_DATE(date,"%c/%e/%Y %r"),"%Y/%m/%d %H:%i:%s") WHERE date LIKE "%M";