1 mysql 中处理
SELECT STR_TO_DATE('Thu Jul 20 15:04:03 2017','%a %b %e %T %Y %Y %Y') from dual ;
STR_TO_DATE(REPLACE('Tue Sep 13 00:00:00 CST 2016', '00:00:00 CST ', '') ,'%a %b %e %Y %Y %Y')
2 java中处理
String date = "Tue Sep 13 00:00:00 CST 2016";
SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd HH:mm:ss z yyyy",Locale.US);
Date d=sdf.parse(date);
sdf=new SimpleDateFormat("yyyyMMdd");
System.out.println(sdf.format(d));