SQL语句查询日期??

[lc315439849]

比如查找2008-1-10 8:00:00 到 2008-5-1 20:00:00这段时间内的记录怎么写??
数据库太烂, 能否给段代码~~! //表名 LogDate

[wzy_love_sly]

select * from LogDate
where dt between '2008-1-10 8:00:00' and '2008-5-1 20:00:00'

[lgxyz]

SELECT * FROM LOGDATE WHERE 字段 >='2008-1-10 8:00:00' AND 字段 <='2008-5-1 20:00:00'

[chuifengde]

select * from [Table] where field between '2008-1-10 8:00:00' and '2008-5-1 20:00:00'

[wzy_love_sly]

declare @logdate table (dt datetime)
insert into @logdate select '2008-1-10 00:00:00'
insert into @logdate select '2008-1-10 10:00:00'
insert into @logdate select '2008-5-1 19:00:00'
insert into @logdate select '2008-5-1 20:00:00'
insert into @logdate select '2008-5-1 21:00:00'

select * from @logdate
where dt between '2008-1-10' and '2008-5-1 20:00:00'

2008-01-10 00:00:00.000
2008-01-10 10:00:00.000
2008-05-01 19:00:00.000
2008-05-01 20:00:00.000

select * from @logdate
where cast(convert(varchar(10),dt,120) as datetime) between '2008-1-10' and '2008-5-1'

2008-01-10 00:00:00.000
2008-01-10 10:00:00.000
2008-05-01 19:00:00.000
2008-05-01 20:00:00.000
2008-05-01 21:00:00.000

[lc315439849]

多谢,