Re: DATE subtraction

Hello,

And what you would expect when you substract dates...???

There is a function MONTHS_BETWEEN(d1,d2) returning number of months between dates d1 and d2.

Hth,

Erika

Chris Chi wrote:
>
> Hi
>
> How can I make DATE subtraction, as below :
>
> declare
> dtFrom DATE;
> dtEnd DATE;
> dtResult DATE;
> begin
> dtResult := dtEnd - dtFrom; -- <- PLS-00382 occurred...
> end;
>
> Is anyone know how to resolve this problem ?
>
> Thanks
>
> Chris Chi
Received on Wed Sep 27 2000 - 04:53:50 CDT