AND pgm.create_time<= date_add(STR_TO_DATE(#{query.endDate},'%Y-%m-%d'),interval 1 day)
03-18
1842
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-28
1006
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-29
1054
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
AND pgm.create_time<= date_add(STR_TO_DATE(#{query.endDate},'%Y-%m-%d'),interval 1 day)