#因为between包含两边的边界值,是[]闭区间,下面的sql查到的是所有的数据
select * from person where add_time between "2021-01-01 09:00:00" and "2021-01-03 14:15:00";
#下面查到的数据只有2条
select * from person where add_time between "2021-01-01 09:00:01" and "2021-01-03 14:15:00";```
sql中查询某个时间段内的数据
最新推荐文章于 2024-10-11 14:42:28 发布