DATE BUILT IN FUNCTIONS

MONTHS_BETWEEN() - RETURNS THE NUMBER OF MONTHS BETWEEN 2 DATES

MONTHS_BETWEEN('01-MAR-15','01-JAN-15')=2

ADD_MONTHS() - ADDS MONTHS TO A DATE

ADD_MONTHS('01-MAR-15',3)='01-JUN-15'

LAST_DAY() - RETURNS THE LAST DAY OF THE MONTH

LAST_DAY('01-MAR-15')='31-MAR-15'

NEXT_DAY() - RETURNS THE NEXT DAY MENTIONED IN THE ARGUMENT

NEXT_DAY('01-MAR-15','WEDNESDAY')='04-MAR-15'

Back To Top- Home - Category