Re: DATE subtraction
From: Swaminathan. N <nospam_at_indya1.com>
Date: Wed, 27 Sep 2000 15:36:45 +0530
Message-ID: <39D1C6B5.B0B56F47_at_indya1.com>
Date: Wed, 27 Sep 2000 15:36:45 +0530
Message-ID: <39D1C6B5.B0B56F47_at_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 - 12:06:45 CEST