Date Help

[Quoted] [Quoted] I have a file that give me a reference date as the number of days since 1/1/985. So if I know I am starting with the date 2/13/2003 and run:

select (TO_DATE('02/12/2003' , 'MM-DD-YYYY') - (TO_DATE('01/01/1985', 'MM-DD-YYYY'))) "Days"from dual

I receive 6616.

That matches the file I have with the number 6616 in it.

So - now I need to say: I know I have a number 6616 and it is the number of [Quoted] days since 1/1/985. How do I convert the 6616 BACK into 2/13/2003? I probably have to do a bit of math but seem to be at a loss.

Any help is appreciated,

Kevin Received on Wed Feb 12 2003 - 20:47:53 CET