between and 查询的问题

[zhuwenli]

create table table1
(
t_id int,
s_DateTime datetime
)
go
insert into table1 values(1,getDate())
insert into table1 values(2,getDate())
我怎么用 select ...between and 查询呢？
我查询的条件都是年月日的数据如between'2007-04-23'and'2007-04-25'
应该怎么写呢？？请大家帮忙啦！

[wgzaaa]

select * from table1 where convert(varchar(10),s_DateTime,120) between '2007-04-23'and'2007-04-25'

[junshanhudazhaxi]

select * from t2
where s_DateTime between '2007-05-01' and '2007-05-05'
直接这样就可以检索了！

[wgzaaa]

直接写后面要加一天，因为不写后面的时分秒，是一天中最小的日期，

[OracleRoob]

select *
from table1
where s_DateTime >='2007-04-23' and s_DateTime< '2007-04-26'

[jinboychen]

以上做法都对,,高手就是高手

[xiao_yi]

总感觉:
select * from table1 where convert(varchar(10),s_DateTime,120) between '2007-04-23'and'2007-04-25'

这样写还是好点,不管数据库表table1中s_DateTime字段日期格式为何样?

都转换成为****_**_** 格式...一来慎重,好来高效...

[OracleRoob]

每行的时间都要用convert转换，这样高效?


效率低。


效率最高的：

select *
from table1
where s_DateTime >='2007-04-23' and s_DateTime< '2007-04-26'