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: <ringbo_at_hotmail.com>
Date: Wed, 27 Sep 2000 12:25:03 +0200
Message-ID: <39D1CAFF.D519DCB2@hotmail.com>

Hi,

The subtraction as you make it will result in a number (of days).

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

--
Kind regards

Michael Ringbo

(please remove NOSPAM) from the email address when contacting)
Received on Wed Sep 27 2000 - 05:25:03 CDT

Original text of this message

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