Re: [D2K] Add Date
From: SKurosky <skurosky_at_aol.com>
Date: 23 Feb 2000 18:34:35 GMT
Message-ID: <20000223133435.20471.00000236_at_ng-fb1.aol.com>
Date: 23 Feb 2000 18:34:35 GMT
Message-ID: <20000223133435.20471.00000236_at_ng-fb1.aol.com>
>Dante Wrote:
>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
>
>--
>Dante,
Select sysdate+2
from dual;
WILL work.
Or if you have a date column in your table;
Select date_col + 2
from table_name;
will work
Hth
Sandy
>
>
>
>
>
>
Received on Wed Feb 23 2000 - 19:34:35 CET