Oracle enables you to extract the day, month, and year from a date using an extract function: select extract(day from sysdate) as only_day from dual select extract(month from sysdate) as only_month from dual select extract(year from sysdate) as only_year from dual. ADD_MONTHS(date, n) – Adds the specific number of months (n) to a date. The ‘n’ can be both negative and positive: