Mybatis查询时间段数据包含结束时间当天数据
create_time BETWEEN date_format(#{beginTime},'%y-%m-%d')
AND DATE_ADD(date_format(#{beginTime},'%y-%m-%d'), INTERVAL TIMESTAMPDIFF(MONTH,#{beginTime},#{endTime}) +1 MONTH)
GROUP BY date_format(create_time,'%y-%m')
create_time BETWEEN date_format(#{beginTime},'%y-%m-%d')
AND DATE_ADD(date_format(#{beginTime},'%y-%m-%d'), INTERVAL TIMESTAMPDIFF(MONTH,#{beginTime},#{endTime}) +1 MONTH)
GROUP BY date_format(create_time,'%y-%m')