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...") |
|||
| Line 3: | Line 3: | ||
==ADD_MONTHS() - ADDS MONTHS TO A DATE == | ==ADD_MONTHS() - ADDS MONTHS TO A DATE == | ||
ADD_MONTHS('01-MAR-15',3)=' | ADD_MONTHS('01-MAR-15',3)='01-JUN-15' | ||
==LAST_DAY() - RETURNS THE LAST DAY OF THE MONTH== | ==LAST_DAY() - RETURNS THE LAST DAY OF THE MONTH== | ||
Revision as of 19:34, 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)='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'