[?] Period calculation..
From: Jong Soo Lee <stmcdc_at_bora.dacom.co.kr>
Date: 1996/04/22
Message-ID: <4lg4m0$944_at_nis.dacom.co.kr>#1/1
Date: 1996/04/22
Message-ID: <4lg4m0$944_at_nis.dacom.co.kr>#1/1
Hi~ there,
Want to calculate period as follows;
select sysdate - dateColumn from emp;
All I wanna do is 'yy/mm/dd' formatted period.
select sysdate + number from emp; or
select (sysdate + 30) newdate from emp; works.
But select trunc(sysdate - dateColumn) newdate from emp; returns around 2800 when dateColumn is 01-JAN-1989.
How can I convert 2800 to dated in forms of 'yyyy/mm/dd'? or select to_date((sysdate - dateColumn), 'yyyy/mm/dd') newdate from emp;
Any comment wil be highly appreciated.
TIA form your help.
Best regards,
Tristan.
PS: pls mail me to stmljsr_at_xmail.lgeds.co.kr : Received on Mon Apr 22 1996 - 00:00:00 CEST