查看:
SELECT STR_TO_DATE( 'Fri Sep 28 10:30:00 CST 2018' , '%W %M %d %H:%i:%S CST %Y') AS date;
修改:
UPDATE t_table
SET `time` = DATE_FORMAT( STR_TO_DATE( `time`, '%W %M %d %H:%i:%S CST %Y' ), '%Y-%m-%d %H:%i:%S' )
WHERE
`time` LIKE '%CST%';