sql查询当天、当月、当年时间

一、查询当天
select * from Table_a WHERE CONVERT(varchar(7),Table_a.Time,120)=CONVERT(varchar(7),getdate(),120)
二、查询当月
select * from Table_a WHERE YEAR(Table_a.Time) = YEAR(getdate()) and MONTH(Table_a.Time)=MONTH(getdate())
三、查询当年
select * from Table_a WHERE YEAR(Table_a.Time) = YEAR(getdate())