新手请教：SQLserver中有一datetime字段selldate不知用什么函数能取出他的时间，convert(varchar(10),selldate,102)怎么什么记录也查不到？？

[ssd]

select * from table1 where convert(varchar(10),selldate,102)='2001-12-12'
怎么什么记录也查不到

[kanghl]

select * from table1 where convert(char(10),selldate,102)='2001.12.12'
select * from table1 where convert(char(10),selldate,111)='2001/12/12'

[三杯倒]

应该把'2001-12-12'，转换成date型比较

select * from table1 where convert(varchar(10),selldate,102)='2001-12-12'
如果selldate为索引，此索引将不起任何意义

[Rayking]

select selldate-cast(selldate-0.5 as int) as 你要的时间 from table1

[蓝天]

select * from table where year(selldate)=2001 and month(selldate)=12 and day(selldate)=12

[netcar]

将操作系统的短日期格式设置为yyyy-M-d或者yyyy-MM-dd