select * from biao where convert(char(10),time,121)='2004-05-29'
select * from biao where To_Char(time, '格式字符串') like '%2004-05-29%'
SELECT * FROM sales WHERE datediff(year,ord_date,'1994-9-14')=0
select * from biao where datediff(day,time,'2004-05-29')=0 这个就行了
列time,是datetime的时间格式,不能直接同字符串比较; 可用 select * from biao where datediff(day,time,'2004-05-29')=0 或 select * from biao where substring(convert(varchar(20),time,120),1,10))='2004-05-29'进行比较
FROM sales
WHERE datediff(year,ord_date,'1994-9-14')=0
这个就行了
可用
select * from biao where datediff(day,time,'2004-05-29')=0
或
select * from biao where substring(convert(varchar(20),time,120),1,10))='2004-05-29'进行比较