05 Functions - Date and Time

ADD_MONTHS:   adds a NUMBER OF months TO a specified DATE

LAST_DAY:    returns the LAST DAY OF a specified MONTH

MONTHS_BETWEEN: how many months fall BETWEEN MONTH x AND MONTH y

NEW_TIME:    adjust the TIME according TO the TIME ZONE you ARE IN

NEXT_DAY   finds the NAME OF the FIRST DAY OF the week that IS equal TO OR later than another specified DATE

SYSDATE   returns the system TIME AND DATE :