mysql 格式化字符串时间查询

 
 select `r`.*  from `table_aaa` as `r` left join `table_bbb` as `m` on `r`.`idNo` = `m`.`me_no`
 where ((CONVERT(r.money,DECIMAL(10,2)) >= 1) and (CONVERT(r.money,DECIMAL(10,2)) <= 90) and (DATE_FORMAT(r.stringTime,'%Y-%m-%d') >= '2023-01-16') and (DATE_FORMAT(r.stringTime,'%Y-%m-%d') <= '2023-01-18')) order by `id` desc limit 20 offset 0
 

(47条消息) MySQL基础操作——字符串截取与格式转换_Harley_lee的博客-CSDN博客
https://blog.csdn.net/Simon_LHM/article/details/108814317