前台选择的日期格式是yyyy-MM-dd，数据库中是Timestamp，查不到结束日期当天的数据

一、在程序代码中把date类型转成加时分秒的String

String createTimeStart = (String) paramMap.get("createTimeStart");
String createTimeEnd = (String) paramMap.get("createTimeEnd");
if (!StringUtil.isEmpty(createTimeStart)) {
    paramMap.put("createTimeStart", createTimeStart + " 00:00:00");
}
if (!StringUtil.isEmpty(createTimeEnd)) {
    paramMap.put("createTimeEnd", createTimeEnd + " 23:59:59");
}

二、在sql中修改
方式一

<if test="beginTime!= null  and  beginTime!=''" >
    <![CDATA[ And rr.REPAY_DATE>=#{beginTime} ]]>
</if>
<if test="endTime!= null and endTime!=''">
   <![CDATA[ And  rr.REPAY_DATE<date_add(#{endTime}, interval 1 day) ]]>
</if>

方式二

<if test="null != createTimeStart and createTimeStart != ''">
    <![CDATA[ AND TO_DAYS(c.CREATE_TIME) >= TO_DAYS(#{createTimeStart}) ]]>
</if>
<if test="null != createTimeEnd and createTimeEnd != ''">
     <![CDATA[ AND TO_DAYS(c.CREATE_TIME) <= TO_DAYS(#{createTimeEnd}) ]]>
 </if>