mysql 时间格式转换

 

 

 

sql:

select Date_Format(if (str_to_date('08/14/2008', '%m/%d/%Y %r') is null, if (
str_to_date('08/14/2008', '%Y-%m-%d') is null, str_to_date('08/14/2008',
 '%c/%e/%Y %T'), str_to_date('08/14/2008', '%Y-%m-%d')), str_to_date(
 '08/14/2008', '%m/%d/%Y %r')), '%Y-%m-%d') as tr_date