SELECT * FROM CC WHERE YEAR(CC)=YEAR(GETDATE()) AND MONTH(CC)=MONTH(GETDATE()) 或者 SELECT * FROM CC WHERE CONVERT(VARCHAR(7),CC,120)=CONVERT(VARCHAR(7),GETDATE(),120)
YEAR(dt)=YEAR(GETDATE()) AND MONTH(DT)=MONTH(GETDATE())
select * from cc where month(dt) =month(getdate())
忘了考虑年份了。 select * from cc where year(dt)= year(dt) and month(dt) =month(getdate())
select * from cc where datepart(yy,dt)='2010' and datepart(mm,dt)='08'
获得当月数据: select * from cc where (datediff(mm,dt,getdate())=0) order by dt
select *from cc where convert(varchar(6),dt,112)= convert(varchar(6),getdate(),112)
或者
SELECT * FROM CC WHERE CONVERT(VARCHAR(7),CC,120)=CONVERT(VARCHAR(7),GETDATE(),120)
select * from cc where month(dt) =month(getdate())
select * from cc where year(dt)= year(dt) and month(dt) =month(getdate())
select * from cc
where (datediff(mm,dt,getdate())=0)
order by dt
select *from cc where convert(varchar(6),dt,112)= convert(varchar(6),getdate(),112)