Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> [D2K] Add Date
How can I find out the date of three days later in Developer/2000?
I found that there is a function called next_day which can return the date of the next weekday. But I did not find any function which can achieve my objective.
I have also tried
SELECT sysdate
into curr_date
from dual;
It works, but where I replace sysdate with sysdate+2, it gives me an error.
Thanks for your help and kind attention.
Dante
--
e-mail : c8354710_at_comp.polyu.edu.hk
URL : http://www.comp.polyu.edu.hk/~c8354710
Received on Wed Feb 23 2000 - 08:27:13 CST
![]() |
![]() |