With this little snippets i start the series of code snippets. For each snippest i reports the portability, type and languages.

SO: All support from Oracle
Type: DataBase
Language: PL\SQL
Title: add a day to oracle date

For add a day to oracle date you must simple add a interger to date for example.

select sysdate + 1 from dual;

increments one day the current system date.

To incremente a month you can use a function ADD_MONTHS

select ADD_MONTHS(sysdate,1) from dual;

this increments one months the system date are useful because add a day number of next month.

To add a year you can also use this

select sysdate + 365 from dual;