Quick Search:
 
 Oracle PL/SQL: Date Functions: ADD_MONTHS Jump to:  
Category: >> Oracle PL/SQL >> Date Functions: ADD_MONTHS  

<< lastnext >>

Snippet Name: Date Functions: ADD_MONTHS

Description: Add a month or months to a given date.

Also see:
» FUNCTIONS: date/time
» UPDATE: Update a partitioned table
» UPDATE: Update based on a record
» UPDATE: Update Object Table
» UPDATE: with RETURNING clause
» UPDATE: Nested Table Update example
» UPDATE: Correlated Update
» UPDATE: Update from a SELECT statement
» UPDATE: based on multiple returned val...
» UPDATE: Update based on a query
» UPDATE: Update multiple rows
» UPDATE: update a specific record
» UPDATE: Single row
» Date Functions: EXTRACT
» Date Functions: TO_DSINTERVAL
» Date Functions: TO_NCHAR
» Date Functions: TO_YMINTERVAL
» Date Functions: Calculate elapsed time...
» Date and Time Calculations: Get second...
» Date: Find first day of the month
» Date Calculations
» Date Functions: WHERE Clause Joins
» Date Functions: TRUNC
» Date Functions: SYSDATE
» Date Functions: TO_CHAR
» Date Functions: ROUND
» Date Functions: NEXT_DAY
» Date Functions: NEW_TIME
» Date Functions: MONTHS_BETWEEN
» Date Functions: MIN

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009

ADD_MONTHS(<date>, <number OF months_integer>
 
SELECT ADD_MONTHS(SYSDATE, 2) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('27-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('28-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('29-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('30-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('31-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('01-FEB-2007'), 1) FROM dual;


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org