Msyql 不规则、任意日期转换标准时间

select DATE_FORMAT(STR_TO_DATE(end_date, '%d/%m/%Y'), '%Y-%m-%d') from app_coupon_api 

//------------------------------------------------------------------------------------------------------------------------------------------

select count(*) from  ( select * from app_coupon_api where website = 'Fancyladies.com' and status = 'public' and UNIX_TIMESTAMP(STR_TO_DATE(left(end_date,10), '%m/%d/%Y')) > UNIX_TIMESTAMP(now()) union  select * from app_coupon_api where website = 'Fancyladies.com' and status = 'public' and UNIX_TIMESTAMP(STR_TO_DATE(left(end_date,10), '%m/%d/%Y')) = 0 union  select * from app_coupon_api where website = 'Fancyladies.com' and status = 'public' and end_date is null )t