计算日期,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