Date Functions

  • SYSDATE – current system date/time
  • ADD_MONTHS(date, n)
  • MONTHS_BETWEEN(date1, date2)
  • LAST_DAY(date), NEXT_DAY(date, 'MONDAY')
SELECT SYSDATE, ADD_MONTHS(SYSDATE, 2), MONTHS_BETWEEN(SYSDATE, TO_DATE('01-JAN-2020', 'DD-MON-YYYY')) FROM dual;