如果是一个时间段,选取其最早时间点和最迟时间点:timemin,timemax,参考的sql语句为select * from tbl where time0 between timemin and timemax 如果是两个时间段,那么分别选取两个时间段的最早时间点和最迟时间点,timemin1,timemax1,timemin2,timemax2,参考的sql语句是 select * from tbl where (time0 between timemin1 and timemax1) or (time0 between timemin2 and timemax2) 以此类推。
orale 查询两个时间段内的数据
最新推荐文章于 2024-06-06 14:27:37 发布