SELECT DATEPART(WEEK, GETDATE())

SELECT DATEPART(WEEKDAY, GETDATE())

SELECT DATENAME(WEEKDAY, GETDATE()),  DATENAME (MONTH, GETDATE())

SELECT DAY(GETDATE()),   MONTH(GETDATE()),   YEAR(GETDATE())

SELECT DATEADD(MONTH, 49, GETDATE())

SELECT DATEDIFF (YEAR, '1/1/2009', '1/1/2011')