Oracle 根据date 类型查询的坑

先将date转换成字符串

paramterMap.put("startDate", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(start));
			paramterMap.put("endDate", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(end));

	<if test="startDate != null">
			<![CDATA[ AND a.EVENT_TIME >= TO_DATE (#{startDate},'yyyy-mm-dd hh24:mi:ss')]]> 
		</if>
		<if test="endDate != null">
			<![CDATA[ AND a.EVENT_TIME <= TO_DATE (#{endDate},'yyyy-mm-dd hh24:mi:ss')]]> 
		</if>