新手请教：SQLserver中有一datetime字段selldate不知用什么函数能取出他的时间，好象date(selldate)不行

[ssd]

sql="select * from table1 where date(selldate)='"&searchdate&"'"好象不行

[xmao]

用convert 函数
sql="select * from table1 where convert(varchar(20),selldate,120)='"&searchdate&"'"

[ssd]

不行啊，他说120非法？？？

[free_doctor]

sql="select * from table1 where convert(datetime,selldate,120)=convert(datetime,'"&searchdate&"',120)"

[lazywolf]

sql="select * from table1 where datediff(dd,selldate,'"&searchdate&"')=0"