实例1:
select if (str_to_date(column1, '%m/%d/%Y %r') is null,
if (str_to_date(column1, '%Y-%m-%d') is null,
str_to_date(column1,
'%c/%e/%Y %T'), str_to_date(column1, '%Y-%m-%d')),
str_to_date(column1,
'%m/%d/%Y %r')) as a from t
实例2:
select
DATE_FORMAT(STR_TO_DATE(REPLACE (REPLACE (Date, 'AM', ''), 'PM', ''),
'%c/%e/%Y %k:%i:%s %p'), '%Y-%m-%d') as Date as b from t