---一个表里面有2个字段:开始时间和结束时间.有很多列.我只想查1个小时之内的数据要怎么查 select * from tb where datediff(hh,开始时间,结束时间)<=1
select * from [表] where datediff(MI,[开始时间],[结束时间])<=60 须判断小于等于60分钟 ,如果判断小时的话,比如:'2010-11-15 8:30:00'与'2010-11-15 9:40:00'的值也是一小时,会有误差
select * from [表] where datediff(ss,[开始时间],[结束时间])<=3600 select * from [表] where datediff(s,[开始时间],[结束时间])<=3600 select * from [表] where datediff(n,[开始时间],[结束时间])<=60 select * from [表] where datediff(mi,[开始时间],[结束时间])<=60
from tb
where datediff(hh,结束时间,开始时间)<=1
select * from tb
where datediff(hh,开始时间,结束时间)<=1
from [表]
where datediff(MI,[开始时间],[结束时间])<=60 须判断小于等于60分钟 ,如果判断小时的话,比如:'2010-11-15 8:30:00'与'2010-11-15 9:40:00'的值也是一小时,会有误差
select *
from [表]
where datediff(ss,[开始时间],[结束时间])<=3600
select *
from [表]
where datediff(s,[开始时间],[结束时间])<=3600
select *
from [表]
where datediff(n,[开始时间],[结束时间])<=60
select *
from [表]
where datediff(mi,[开始时间],[结束时间])<=60