Excel日期转Java日期(2019#9#25 11:15:39 转 2019-09-25 11:15:39)

最新推荐文章于 2022-07-06 11:19:11 发布

tanzongbiao

最新推荐文章于 2022-07-06 11:19:11 发布

阅读量540

点赞数

分类专栏： Java 文章标签： Excel日期转Java日期 2019#9#25 11:15:39 转 2019-09-2

本文链接：https://blog.csdn.net/tanzongbiao/article/details/102311602

版权

Java 专栏收录该内容

183 篇文章 4 订阅

订阅专栏

//Excel日期转Java日期(2019#9#25 11:15:39 转 2019-09-25 11:15:39)
   private Date changeDate(String createdDateStr) {
       if(StringUtils.isEmpty(createdDateStr)){
           return null;
       }

       SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
       SimpleDateFormat df2 = new SimpleDateFormat("yyyy-MM-dd");
       Date createdDateReturn = null;
       String dateStrTemp = "";
       if(createdDateStr.indexOf(" ") >= 0){//日前+时间
           String[] aa = createdDateStr.split(" ");
           String dateStr = aa[0];
           String timeStr = aa[1];

           String[] bb = dateStr.split("#");
           dateStrTemp += bb[0] + "-";//yyyy
           if(bb[1].length() < 2){
               dateStrTemp += "0" + bb[1] + "-";//MM
           }else{
               dateStrTemp += bb[1] + "-";
           }
           if(bb[2].length() < 2){
               dateStrTemp += "0" + bb[2] + " ";//MM
           }else{
               dateStrTemp += bb[2] + " ";
           }

           String[] cc = timeStr.split(":");
           if(cc[0].length() < 2){
               dateStrTemp += "0" + cc[0] + ":";//HH
           }else{
               dateStrTemp += cc[0] + ":";
           }
           if(cc[1].length() < 2){
               dateStrTemp += "0" + cc[1] + ":";//mm
           }else{
               dateStrTemp += cc[1] + ":";
           }
           if(cc[2].length() < 2){
               dateStrTemp += "0" + cc[2];//ss
           }else{
               dateStrTemp += cc[2];
           }

           try {
               createdDateReturn = df.parse(dateStrTemp);
           } catch (ParseException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }else{//仅日期
           String[] bb = createdDateStr.split("#");
           dateStrTemp += bb[0] + "-";//yyyy
           if(bb[1].length() < 2){
               dateStrTemp += "0" + bb[1] + "-";//MM
           }else{
               dateStrTemp += bb[1] + "-";
           }
           if(bb[2].length() < 2){
               dateStrTemp += "0" + bb[2];//MM
           }else{
               dateStrTemp += bb[2];
           }

           try {
               createdDateReturn = df2.parse(dateStrTemp);
           } catch (ParseException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }

       //System.out.println(dateStrTemp);
       return createdDateReturn;
}