Re: DATE subtraction

From: Swaminathan. N <nospam_at_indya1.com>
Date: Wed, 27 Sep 2000 15:36:45 +0530
Message-ID: <39D1C6B5.B0B56F47@indya1.com>

changing the dtResult Datatype will work. may be u can convert this later using TO_DATE.

declare
  dtFrom DATE;
  dtEnd DATE;
  dtResult VARCHAR2(20);
begin
  dtResult := dtEnd - dtFrom;
end;

--swami

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 - 05:06:45 CDT