SQL SERVER END OF MONTH EOMONTH FORMULA

SQL SERVER END OF MONTH EOMONTH FORMULA

-- HI VIEWERS

-- TODAY WE ARE LOOKING AT THE END OF MONTH FORMULA

-- THE END OF MONTH (EOMONTH) FORMULA TELLS YOU WHAT THE LAST DAY OF THE MONTH IS FOR THE STATED MONTH GIVEN

-- LET US BEGIN

-- FIRST START THE QUERY WITH THE KEYWORD SELECT

-- FOLLOWED BY THE EOMONTH FUNCTION

-- THEORY:

-- SELECT EOMONTH(DATETIME VALUE,0 FOR CURRENT MONTH)

-- SELECT EOMONTH(DATETIME VALUE,1 FOR NEXT MONTH)

-- AND SO ON

-- EXAMPLE:

-- CURRENT MONTH FOLLOWS

SELECT EOMONTH(GETDATE(),0);

-- NEXT MONTH

SELECT EOMONTH(GETDATE(),1);

-- MONTH AFTER NEXT

SELECT EOMONTH(GETDATE(),2);

-- THAT IS IT