Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DATE subtraction

Re: DATE subtraction

From: Erika Grondzakova <Erika.Grondzakova_at_cern.ch>
Date: Wed, 27 Sep 2000 11:53:50 +0200
Message-ID: <39D1C3AE.49EFF0E9@cern.ch>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US