求SQL，关于时间段查询

[panzi667]

有一个表A,字段：id,time1,time2
现在有一个查询条件，时间字段s1,s2,如何查询出time1,time2与s1,s2有交集的记录
比如:time1的值是2012-04-01,time2的值是2012-04-10
如果s1的值是2012-03-01，s2的值是2012-03-05，那么这两个时间段是没有交集
如果s1的值是2012-03-01，s2的值是2012-04-05，那么这两个时间段是有交集的

[panzi667]

[Quote=引用 2 楼 的回复:]
SQL code

select * from test
where (s1 between time1 and time2) or (s2 between time1 and time2)
[/Quote]

这个我测试咯，符合我的要求，谢谢！

[让你望见影子的墙]

select *
from tb
where time1<s2

[开着拖拉机泡妞]

select * from test
where (s1 between time1 and time2) or (s2 between time1 and time2)

[人生无悔]

select * from A 
where (s1 between time1 and time2)
or (s2 between time1 and time2)
or (time1 between s1 and s2)

[我腫了]

--有一个表A,字段：id,time1,time2
--现在有一个查询条件，时间字段s1,s2,如何查询出time1,time2与s1,s2有交集的记录
--比如:time1的值是2012-04-01,time2的值是2012-04-10
--如果s1的值是2012-03-01，s2的值是2012-03-05，那么这两个时间段是没有交集
--如果s1的值是2012-03-01，s2的值是2012-04-05，那么这两个时间段是有交集的

SELECT 1 FROM A
WHERE (time1 between s1 and s2)
or (time2 between s1 and s2)