SQL日期函数及应用

select YEAR(GETDATE ()) as 年份
select MONTH(GETDATE ()) as 月份




select DATENAME (YEAR ,GETDATE ()) as 年份
select DATENAME (MONTH  ,GETDATE ()) as 月份
select DATENAME (WEEKDAY  ,GETDATE ()) as 星期几
select DATENAME (WEEK ,GETDATE ()) as 第几周


DATEADD (datepart , number, date )，在向指定日期加上一段时间的基础上，返回新的 datetime 值。
select DATEADD (MM ,2,GETDATE ()) as 当前日期的两个月后
select DATEADD (YY ,2,'2010/01/11') as 两个月后
select YEAR (DATEADD (YY ,2,GETDATE ())) 
select MONTH (DATEADD (MM ,2,GETDATE ()))as 只显示年份
select DATEADD (YY ,2,'2010/01/11')
select CONVERT(varchar(12) , DATEADD (MM ,2,GETDATE ()), 102 )


DATEDIFF ( date-part, date-expression-1, date-expression-2 )返回两个日期之间的间隔。
select DATEDIFF (MONTH ,GETDATE (),'20140131')  
select DATEDIFF (WEEK ,GETDATE (),'20140131')


DATEPART ( datepart ,date )返回代表指定日期的指定日期部分的整数。
select DATEPART (MONTH ,GETDATE ())
与
select MONTH (GETDATE ())等同的效果