select getdate() select dateadd(year,-1,getdate()) select datediff(day,getdate(),dateadd(day,2,getdate()) ) Select datepart(month, dateadd(month,1,getdate())) Select datepart(hour, dateadd(month,1,getdate())) Select datename(weekday, getdate()) select 当前日期=convert(varchar(4),getdate(),20),当前时间=convert(varchar(8),getdate(),114) select datename(hh,getdate()) select 本年第多少周=datename(week,getdate()),今天是周几=datename(weekday,getdate()) select*from AAE_GroupPlan select datepart(year,getdate())+'0'