___DATE, DATE, DATE Subtraction

From: Chris Chi <stvllium_at_ms18.hinet.net>
Date: Thu, 28 Jun 2001 11:09:05 +0800
Message-ID: <9he8ve$skq@netnews.hinet.net>

Hi

  How can I subtract DATE variable by another DATE variable, as below :

  declare

     StartDate DATE;
     EndDate  DATE;
     ResultDate DATE;
     XXX CHAR(10);
  begin


     ......

     ResultDate := EndDate - StartDate;  -- Subtraction


     ......

     XXX := TO_CHAR(ResultDate, '...');

  end;

  Thanks

  Chris from Taiwan, R.O.C.    Received on Wed Jun 27 2001 - 22:09:05 CDT