QueryWrapper<SysUser> queryWrapper = new QueryWrapper<>(); // 查询上一个月的所有的订单数据 queryWrapper.and(wrapper -> wrapper.apply("DATE_FORMAT(create_time, 'YYYY-MM') = DATE_FORMAT(now(),'YYYY-MM') ")); List<SysUser> list = sysUserService.list(queryWrapper);
QueryWrapper<SysUser> queryWrapper = new QueryWrapper<>(); // 查询上一个月的所有的订单数据 queryWrapper.and(wrapper -> wrapper.apply("DATE_FORMAT(create_time, 'YYYY-MM') = DATE_FORMAT(now(),'YYYY-MM') ")); List<SysUser> list = sysUserService.list(queryWrapper);