Question

求一SQL查询语句，查询每天某一时间段记录。

查询每天某一时间段记录，如8点到9点，
例如 表AAA ,字段 A,B,TIME
TIME 类型为datetime
多谢！！！！
TIME 类型为datetime 如 2008-10-10 16:44:12

Answer 1

举例如下：
select * from timetable
where datediff(mi,'2008-10-10 8:00:00',timet)>=1 and datediff (mi,'2008-10-10 9:00:00',timet)<=30

Answer 2

select xx from AAA
where datediff(h,8,time)>=0 and datediff(h,9,time)<=0
order by time

Answer 3

select xx from AAA
where TIME between '8' and '9'