select * from 表名 where YEAR(add_time) = '2023' and QUARTER(add_time) = 1
按年查询(查询出来的日期格式转换)
and DATE_FORMAT(t.add_time,'%Y')=#{dateYear}
select * from 表名 where YEAR(add_time) = '2023' and QUARTER(add_time) = 1
按年查询(查询出来的日期格式转换)
and DATE_FORMAT(t.add_time,'%Y')=#{dateYear}