SELECT * from pvm_1 where CONVERT(varchar(10),arrival,120) like '%2003%' order by arrival desc
你为什么非要like呢??select year(getdate()) --年
select month(getdate()) --月
select day(getdate()) --日--查当月:
select * from pvm_1 where datediff(month,arrival,getdate())=0
--当天:
select * from pvm_1 where datediff(day,arrival,getdate())=0--年
select * from pvm_1 where year(arrival)=2003这么多方法
你为什么非要like呢??select year(getdate()) --年
select month(getdate()) --月
select day(getdate()) --日--查当月:
select * from pvm_1 where datediff(month,arrival,getdate())=0
--当天:
select * from pvm_1 where datediff(day,arrival,getdate())=0--年
select * from pvm_1 where year(arrival)=2003这么多方法
datepart(year,arrival) = 2003