用了函数式后没有索引
start_time = replace(start_time,left(start_time,4),#{liveYear}),
CONCT:字符串拼接(有年月日形式的字符串不用转换也能和Date类型比较)
select * from tb_holiday tb
where
CONCAT(#{date},'-01') between tb.start_time and tb.end_time
DATE_FORMAT:字符串/日期转换成 'xx-xx-xx’格式的日期(字符串好像不行)
SELECT * FROM tb_holiday
WHERE
DATE_FORMAT(#{date},'%Y-%c-%d') BETWEEN start_time AND end_time