按日期查询问题？

[wenle]

在数据库中日期字段MatchDate的值为：2008-01-08 09:59:05.267
我要查询2008-01-08的数据怎么写SQL语句？
例如：
select * from table1 where matchdate = ？

[JiangHongTao]

convert(char(10),matchdate,120)='2008-01-08'

[JL99000]

在数据库中日期字段MatchDate的值为：2008-01-08 09:59:05.267
我要查询2008-01-08的数据怎么写SQL语句？
例如：
select * from table1 where matchdate = ？

select * from table1 where convert(varchar(10),matchdate,120) ='2008-01-08'

接分

[liangCK]

select * from table1 where matchdate='2008-01-08'

[liangCK]

select * from table1 where convert(char(10),matchdate,120)='2008-01-08'

[wzy_love_sly]

select * from table1 where datediff(dd,matchdate,'2008-01-08')=0

[wzy_love_sly]

declare @a table (dt datetime)
insert into @a select '2008-01-08 09:59:05.267'

select   *   from   @a   where   
datediff(dd,dt,'2008-01-08')=0

[zefuzhang2008]

declare @a table (dt datetime)
insert into @a select '2008-01-08 09:59:05.267'
insert into @a select '2008-01-08 00:59:05.267'
insert into @a select '2008-01-08 12:59:05.267'
insert into @a select '2008-01-08 23:59:05.267'
select * from @a where
dt>='2008-01-08' and dt<'2008-01-08'

[zefuzhang2008]

declare @a table (dt datetime)
insert into @a select '2008-01-08 09:59:05.267'
insert into @a select '2008-01-08 00:59:05.267'
insert into @a select '2008-01-08 12:59:05.267'
insert into @a select '2008-01-08 23:59:05.267'
select * from @a where dt> ='2008-01-08' and dt <'2008-01-09'