Oracle Date Functions Usage and Examples

All the Oracle date functions list is the following:
add_months
current_date
current_timestamp
dbtimezone
extract(datetime)
last_day
months_between
new_time
next_day
round
sysdate
systimestamp
to_date
trunc()

Oracle date function 1.Add_Months

The syntax for the add_months function is:
    Add_Months(date,months)    Get a date added or minused the months.
Example:
          select add_months(date,1) from dual
          date
          ------
          16-Oct-11
          select add_months(date,-1) from dual
           date
           ------
          16-Aug-11

Oracle date function 2.Current_date

Read more