例如把 9/27/2006 转换成 2006-9-27
select DATE_FORMAT(STR_TO_DATE(REPLACE(REPLACE(Date,'AM',''),'PM',''),'%c/%e/%Y %k:%i:%s %p'),'%Y-%m-%d') as Date from table_name
例如把 9/27/2006 转换成 2006-9-27
select DATE_FORMAT(STR_TO_DATE(REPLACE(REPLACE(Date,'AM',''),'PM',''),'%c/%e/%Y %k:%i:%s %p'),'%Y-%m-%d') as Date from table_name