Function add day or add week

[jovery]

Is this what you mean?

SQL> select sysdate from dual;

SYSDATE
---------
13-JAN-03

SQL> select sysdate+1 from dual;

SYSDATE+1
---------
14-JAN-03

SQL> select sysdate+7 from dual;

SYSDATE+7
---------
20-JAN-03

Regards