JAVA SQL 中 date类型的那些事！

1.时间比较的：天 小时 分钟 秒：

public static String getDatePoor(Date endDate, Date nowDate) {
        long nd = 1000 * 24 * 60 * 60;
        long nh = 1000 * 60 * 60;
        long nm = 1000 * 60;
        // long ns = 1000;
        // 获得两个时间的毫秒时间差异
        long diff = endDate.getTime() - nowDate.getTime();
        long day = diff / nd;
        long hour = diff % nd / nh;
        long min = diff % nd % nh / nm;
        return hour+"";
    }

2.将时间转化成为字符串 

SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
            Date d =new Date;
            String s=format.format(d);

3.字符串转换时间 

 String time = "2020-02-02 02:02:02";
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            Date newTime = format.parse(time);
            System.out.println("转换以后的时间：："+newTime);
      

4.Mybatis中时间的比较

1.date类型与 string的比较
<if test="createDateStr != null and createDateStr != '' ">
 AND  DATE_FORMAT(a.create_date,'%Y-%m-%d') = str_to_date(#{createDateStr},'%Y-%m-%d')
</if>

2.date类型与 date类型的比较		
<if test="createDateStr != null and createDateStr != '' ">	
 AND  DATE_FORMAT(a.create_date,'%Y-%m-%d') = DATE_FORMAT(#{createDateStr},'%Y-%m-%d')
</if>