[?] Period calculation..

Hi~ there,

 I've posted this one sometime ago.
 However nobody answered me. And I am still waiting for any advise.

 TIA,  Tristan

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 Sat Apr 27 1996 - 00:00:00 CEST