计算日期代码

计算日期，selectgetdate()as'今日现在'selectyear('2007-10-11')selectmonth('2007-10-11')selectday(getdate())as'今天'selectdateadd(day,100,getdate())/*selectdatediff(day,'1988-08-29',getdate())selectdatediff(month,'1988-08-29',getdate())selectdatediff(year,'1988-08