Function to calculate time between date
From: C M <cmarcoux_at_webnet.qc.ca>
Date: Wed, 08 Nov 2000 18:30:06 GMT
Message-ID: <OYgO5.239$Wd4.27296047_at_news1.mtl.metronet.ca>
Extented warranty number(2);
Date: Wed, 08 Nov 2000 18:30:06 GMT
Message-ID: <OYgO5.239$Wd4.27296047_at_news1.mtl.metronet.ca>
Hi.
[Quoted] I Need to create a function that will calculate the time left for a warranty.
In my table I have fields for
Purchase_date date; Warranty number(2);
Extented warranty number(2);
End of warranty varchar2(15);
(this field must be update every time sysdate change).
And the output must be exp: 1 year 6 month 3 days.
If no more warranty It must be written "Expired"
I presume I will do it with a function.
I realy need help... Dont know how...
[Quoted] Big thanks in avanced... Received on Wed Nov 08 2000 - 19:30:06 CET