22,210
社区成员
发帖
与我相关
我的任务
分享
select * from TB where (start_date between '2011/3/5 0:00:00' and '2011/3/10 0:00:00')
or (end_date between '2011/3/5 0:00:00' and '2011/3/10 0:00:00')
or ('2011/3/5 0:00:00' between start_date and end_date)
or ( '2011/3/10 0:00:00' between start_date and end_date)
select * from tb where (start_time between '2011/3/5 0:00:00' and '2011/3/10 0:00:00'
and end_time between '2011/3/5 0:00:00' and '2011/3/10 0:00:00')
or ('2011/3/5 0:00:00' between start_time and end_time
and '2011/3/10 0:00:00' between start_time and end_time)
select * from tb where start_time between '2011/3/5 0:00:00' and '2011/3/10 0:00:00'
and end_time between '2011/3/5 0:00:00' and '2011/3/10 0:00:00'