例如三个四个字段id int
title varchar
stime date
etime date数据
id title stime etime
1 '开会' 2010-11-20 2010-11-25
指定时间为 2010-11-21 或 2010-11-19如果为2010-11-21 则返回
id title stime etime
1 '开会' 2010-11-20 2010-11-25
如果为2010-11-19
则没有数据返回。sql如何写?谢谢各位高手!
title varchar
stime date
etime date数据
id title stime etime
1 '开会' 2010-11-20 2010-11-25
指定时间为 2010-11-21 或 2010-11-19如果为2010-11-21 则返回
id title stime etime
1 '开会' 2010-11-20 2010-11-25
如果为2010-11-19
则没有数据返回。sql如何写?谢谢各位高手!
select * from table1 where '2010-11-19' between stime and etime;
select * from table1 where stime <= '2010-11-19' and etime >= '2010-11-19';