关于Between and查询日期边界问题和查不到当天日期的问题

解决办法 加一天

mysql写法

select * from table where date between '2018-07-21' and date_add('2018-07-23',interval 1 day)
mybatis

mybatis 写法

 <if test="beginGenerateTime != null and beginGenerateTime != '' and endGenerateTime != null and endGenerateTime != ''"> and generate_time between #{beginGenerateTime} and DATE_ADD(#{endGenerateTime}, INTERVAL 1 DAY)</if>