SQL 08-12-18

--14
SELECT GETDATE() as currentdatetime

SELECT CAST(GETDATE() as date) as currentdate;

SELECT CAST(GETDATE() as time) as currenttime;

SELECT YEAR(GETDATE()) as currentyear;

SELECT MONTH(GETDATE()) as currentmonth;

SELECT DAY(GETDATE()) as currentday;

SELECT DATEPART(wk, GETDATE()) as currentweek


SELECT DateName( month , DateAdd( month , DATEPART(MONTH, GETDATE()) , 0 ) - 1 ) as currentmonthname

--15

--16
SELECT DateAdd(month, DATEPART(MONTH, GETDATE()), 3)