___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>
end;
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