计算日期代码

计算日期，select getdate() as '今日现在' select year('2007-10-11') select month('2007-10-11') select day(getdate())as '今天' select dateadd(day,100,getdate()) /*select datediff(day,'1988-08-29',getdate()) select datediff(month,'1988-08-29',getdate()) select datediff(year,'1988-08-29',getdate())*/