select * from aaaa where f >=#00:10:20# and f<=#00:06:56#
假定时间的字段名为time，SQL语句如下：select * from 表名 where time>=#00:11:20# and time <=#00:06:56#
select * from table1 where time1 between @atime and @btime
