select * from test_case where create_time >= '2023-8-28 00:00:00' and create_time <= '2023-8-28 23:59:59';
select * from test_case where create_time >= '#{startTime} 00:00:00' and create_time <= '#{endTime} 23:59:59';
select * from test_case where STR_TO_DATE(create_time, '%Y-%m-%d') >= '2023-8.28' AND STR_TO_DATE(create_time, '%Y-%m-%d') <= '2023-8.28'
mapper注意事项
| 字符 |
转义字符 |
描述 |
| > |
> |
大于 |
| >= |
>= |
大于等于 |
| < |
< |
小于 |
| <= |
<= |
小于等于 |
| " |
" |
双引号 |
| ’ |
' |
单引号 |
| & |
& |
and |
