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'

DATE CONVERSION TO CHARACTER DATA

SELECT TO_CHAR(HIRE_DATE, 'Month dd, YYYY') output -> June 07, 1994
SELECT TO_CHAR(HIRE_DATE, fmMonth dd, YYYY') output -> June 7 1994
SELECT TO_CHAR(HIRE_DATE, 'fmMonth ddth, YYYY') output -> June 7th, 1994

Back To Top- Home - Category