Re: Date Function needed

Simply add or substract the desired number of days from your date column:

for example,

select sysdate+2 from dual;

displays the day after tomorrow.

If you have a table MYTABLE containing a date column MYDATE :

select MYDATE-2 from MYTABLE;

is another example query Received on Tue Jun 30 1998 - 13:53:08 CDT