DATE FNCTIONS

select GETDATE()

select DAY('12-22-2014')

select MONTH(getdate())

select YEAR(getdate())

select DATEPART(WEEKDAY,getdate())

select DATEPART(DAY,GETDATE())


select DATEPART(MONTH,getdate())

select DATEPART(YEAR,GETDATE())

select DATEPART(WEEK,GETDATE())

select DATENAME(WEEKDAY,GETDATE())

select DATENAME(DAY,GETDATE())

select DATENAME(WEEK,GETDATE())

select DATENAME(MONTH,GETDATE())

SELECT DATENAME(YEAR,GETDATE())

SELECT DATEADD(DAY,1,GETDATE())

SELECT DATEADD(WEEKDAY,5,GETDATE())

SELECT DATEADD(WEEK,5,GETDATE())

SELECT DATEADD(MONTH,1,GETDATE())

SELECT DATEADD(YEAR,1,GETDATE())

SELECT DATEDIFF(DAY,'01-01-2014',GETDATE())

SELECT DATEDIFF(WEEKDAY,'01-01-2010','12-02-2014')

SELECT DATEDIFF(WEEK,'01-01-2010','12-02-2014')

SELECT DATEDIFF(MONTH,'01-01-2010','12-02-2014')

SELECT DATEDIFF(YEAR,'03-20-1989',getdate())