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 -> DATE subtraction

DATE subtraction

From: Chris Chi <stvllium_at_ms18.hinet.net>
Date: Wed, 27 Sep 2000 17:40:11 +0800
Message-ID: <8qsfd4$nm@netnews.hinet.net>

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:40:11 CDT

Original text of this message

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