Function add day or add week

[akwete]

JIm,

I added the following lines to my function and it worked.


SQL> select sysdate + 1 as ADD_DAY from dual
2 /

ADD_DAY
---------
14-JAN-03

SQL> select sysdate + 7 as ADD_WEEK from dual
2 /

ADD_WEEK
---------
20-JAN-03

Thanks.