SQL SERVER DATEPART FUNCTION

SQL SERVER DATEPART FUNCTION

/* DATEPART FUNCTION USING SQL SERVER SSMS */

--ALRIGHT, WE WILL BE LOOKING AT THE DATEPART FUNCTION IN SQL SERVER TO DISPLAY PART OF A DATE

--START WITH THE KEYWORD, SELECT

-- FOLLOWED BY THE FUNCTION NAME

SELECT DATEPART(DAY,GETDATE());

SELECT DATEPART(WEEK,GETDATE());

SELECT DATEPART(MONTH,GETDATE());

SELECT DATEPART(YEAR,GETDATE());

-- SO THE THEORY IS

-- SELECT FUNCTION NAME(INTERVAL, DATE);

-- THE SEMI-COLON ";" ACTS AS A BATCH TERMINATOR, WHICH CLEAR SEPERATES DIFFERENT PARTS OF CODE

-- HIGHLIGHT CODE AND CLICK EXECUTE OR (F5)

-- AS YOU CAN SEE, TODAY IS THE 14TH AND WE ARE IN WEEK 24, THE MONTH OS 6 OR JUNE AND THE YEAR IS 2014

-- THAT IS IT