Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: DATE subtraction
Chris Chi a écrit :
>
> Hi
>
> How can I make DATE subtraction, as below :
>
> declare
> dtFrom DATE;
> dtEnd DATE;
> dtResult DATE;
> begin
> dtResult := dtEnd - dtFrom; -- <- PLS-00382 occurred...
The difference between two dates is a number of days ... How can it be another date ?
> end;
>
> Is anyone know how to resolve this problem ?
>
> Thanks
>
> Chris Chi
-- Pierre CHARPENAYReceived on Wed Sep 27 2000 - 06:32:11 CDT
![]() |
![]() |