SELECT * FROM team_member WHERE create_time > '2021-08%'
SELECT create_time FROM team_member WHERE DATE_FORMAT(create_time,"%Y-%m") = '2020-08'
void test1() throws ParseException { QueryWrapper<Member> wrapper = new QueryWrapper<>(); // wrapper.last("order by case when parent_id=0 then id else parent_id END,parent_id,id"); // wrapper.addFilter // wrapper.eq("DATE_FORMAT(start_time,\"%Y-%m\")","2021-07"); String dateStr="2021-08-11"; Date userDate = new SimpleDateFormat("yyyy-MM").parse(dateStr); String firstStr = new SimpleDateFormat("yyyy-MM").format(userDate); // wrapper.eq("DATE_FORMAT(start_time,\"%Y-%m\")",firstStr); wrapper.like("start_time",firstStr); List<Member> members = memberMapper.selectList(wrapper); members.forEach(System.out::println); }