将 17-NOV-15 19:20:08.8 格式的数据转换成 yyyy-MM-dd HH:mm:ss 格式
private Date Dateform(String dt) {
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
try {
String y = "20" + dt.substring(7, 9);
String mm = dt.substring(3, 6);
String mo = "01";
switch (mm) {
case "JAN":
mo = "01";
break;
case "FEB":
mo = "02";
break;
case "MAR":
mo = "03";
break;
case "APR":
mo = "04";
break;
case "MAY":
mo = "05";
break;
case "JUN":
mo = "06";
break;
case "JUL":
mo = "07";
break;
case "AUG":
mo = "08";
break;
case "SEP":
mo = "09";
break;
case "OCT":
mo = "10";
break;
case "NOV":
mo = "11";
break;
case "DEC":
mo = "12";
break;
}
String d = dt.substring(0, 2);
String time = dt.substring(10, 18);
return df.parse(y + "-" + mo + "-" + d + " " + time);
} catch (ParseException e) {
System.out.println("转换错误"+e);
return null;
}
}