select * from table where 时间字段 between '时间点1' and '时间点2';