--时间在2000-1-1 2002-2-2之间的 select * from table where shijianziduan between '2000-1-1' and '2000-1-2' --时间年份小于2001 select * from table where datepart(year,shijianziduan)<2001
--时间年份小于2001 select * from A where year(时间)< '2001'
select * from A where year(时间)< '2001'
select * from A where datediff(yy,时间,'2001-0-0')>=0
select * from table where shijianziduan between '2000-1-1' and '2000-1-2'
--时间年份小于2001
select * from table where datepart(year,shijianziduan)<2001
select * from A where year(时间)< '2001'