___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_at_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 Thu Jun 28 2001 - 05:09:05 CEST

Original text of this message