A Developer Gateway To IT World...

Techie Uncle Software Testing Core Java Java Spring C Programming Operating System HTML 5 Java 8 ES6 Project

What is NEXT_DAY and ADD_MONTHS function in oracle 11g?

NEXT_DAY and ADD_MONTHS in oracle 11g

NEXT_DAY and ADD_MONTHS in oracle 11g

SELECT TO_CHAR(NEXT_DAY(ADD_MONTHS (hire_date, 6), 'FRIDAY'), 'fmDay, Month ddth, YYYY') "Next 6 Month Review" FROM employees ORDER BY hire_date;

Here, we have initially called ADD_MONTHS function and then, called NEXT_DAY function.

LEARN TUTORIALS

.

.