Difference between revisions of "DATE BUILT IN FUNCTIONS"
Jump to navigation
Jump to search
(Created page with "==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-1...") |
(No difference)
|
Revision as of 19:33, 5 November 2017
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)='31-MAR-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'