String startDate = "2022-10-10";
String endDate = "2022-10-30";
QueryWrapper<BpSubscribe> queryWrapper = new QueryWrapper<>();
queryWrapper.select().apply(StrUtil.isNotBlank(startDate),
"date_format (create_date,'%Y-%m-%d') >= date_format('" + startDate + "','%Y-%m-%d')")
.apply(StrUtil.isNotBlank(endDate),
"date_format (create_date,'%Y-%m-%d') <= date_format('" + endDate + "','%Y-%m-%d')");
List<BpSubscribe> bpSubscribes = bpSubscribeService.list(queryWrapper);
MybatisPlus按时间段进行查询
最新推荐文章于 2024-05-28 11:27:41 发布