计算日期代码下载

[weixin_39821260]

计算日期，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())*/
相关下载链接：//download.csdn.net/download/peng201314/4991176?utm_source=bbsseo