时间timestamp做条件进行查询

首先要将条件 转换为 时间戳

        long startTime = TimeUtil.parseTimestamp(start);
        long endTime = TimeUtil.parseTimestamp(end);

/*对应工具类*/
   public static long parseTimestamp(String datetime){
        try{
            SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            Date date    = dateformat.parse(datetime);
            return date.getTime()/1000;            
        }catch(Exception e){
             e.printStackTrace();
        }

        return 0;
    }

然后Mapper.xml中 使用BETWEEN and 和 to_timestamp

<if test="startDate !=null and startDate !='' and endDate !=null and endDate !=''">
AND tdnm.create_time BETWEEN to_timestamp(#{startDate}) AND to_timestamp(#{endDate})
</if>