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: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Wed, 27 Sep 2000 13:32:11 +0200
Message-ID: <39D1DABB.817CDCAE@unilog.fr>

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 CHARPENAY
Received on Wed Sep 27 2000 - 06:32:11 CDT

Original text of this message

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