获取月份:select * from table where month(column) =month(getdate())
或者select * from table where convert(varchar(1),column,10)= convert(varchar(1),getdate(),10)
获取年份函数:yaer( getdate() )
获取N年(日,月)前(后)的年份select adddate(yy,N,getdate() )
获取月份:select * from table where month(column) =month(getdate())
或者select * from table where convert(varchar(1),column,10)= convert(varchar(1),getdate(),10)
获取年份函数:yaer( getdate() )
获取N年(日,月)前(后)的年份select adddate(yy,N,getdate() )