菜鸟求个时间段查询的问题请教

[KissRose]

表中有字段timestart="2011-4-28 16:00" timeend="2011-4-28 16:00"
有时间段需要查询timestart="2011-4-28 16:00" timeend="2011-4-28 18:00"
怎样判断查询时间段包含了表中的时间段呢？

[bill024]

判断日期函数isdate()

[AcHerat]

declare @time1 datetime
declare @time2 datetime
set @time1 = '2011-4-1'
set @time2 = '2011-4-28'

select *
from tb
where (timestart between @time1 and @time2) and (timeend between @time1 and @time2)

[Shawn]

declare @time1 datetime
declare @time2 datetime
set @time1 = '2011-4-1'
set @time2 = '2011-4-28'

select *
from tb
where timestart <= @time2 and timeend >= @time1 --注意临界时间:可换成timestart < @time2 and timeend > @time1

[cd731107]

--没太明白楼主的意思，也许是

between timestart and timeend