举例如下：
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
select xx from AAA
where datediff(h,8,time)>=0 and datediff(h,9,time)<=0
order by time
select xx from AAA
where TIME between '8' and '9'
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024