一张表,日期字段cheer_date,查询一下2006年的所有记录,谢谢,请问SQL怎么写?SELECT * FROM [TABLENAME] WHERE YEAR([CHEER_DATE])=2006
SELECT * FROM [TABLENAME] WHERE [CHEER_DATE]>='2006-1-1' AND [CHEER_DATE]<='2006-12-31'
SELECT * FROM [TABLENAME] WHERE DATEDIFF(YEAR,[CHEER_DATE],'2006-1-1')=0
SELECT * FROM tablename WHERE datepart(year,cheer_date)='2006'
日期字段cheer_date,查询一下2006年的所有记录,谢谢,请问SQL怎么写? select * from tb where year(cheer_date) = 2006 or select * from tb where cheer_date >= '2006-01-01' and cheer_date <= '2006-12-31' or select * from tb where left(convert(varchar(10),cheer_date,120),4) = '2006'
WHERE [CHEER_DATE]>='2006-1-1' AND [CHEER_DATE]<='2006-12-31'
select * from tb where year(cheer_date) = 2006
or
select * from tb where cheer_date >= '2006-01-01' and cheer_date <= '2006-12-31'
or
select * from tb where left(convert(varchar(10),cheer_date,120),4) = '2006'