SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSXXX");
SimpleDateFormat sdf2=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//拿到Date对象
Date date1 = sdf1.parse(searchTime[0]);
Date date2 = sdf1.parse(searchTime[1]);
String s1 = sdf2.format(date1).substring(0, 10)+" 00:00:00";
String s2 = sdf2.format(date2).substring(0, 10)+ " 23:59:59";
whereSql+=" and (create_time_ between '"+s1+"' and '"+s2+"')";