MyBatis時(shí)間timestamp做條件進(jìn)行查詢

首先要將條件 轉(zhuǎn)換為 時(shí)間戳

long startTime = TimeUtil.parseTimestamp(start);
long endTime = TimeUtil.parseTimestamp(end);
 
/*對(duì)應(yīng)工具類*/
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>