Re: Date Help

Hi:

If I have understood correctly your question, you want to get the date that is 6616 days later than 01/01/1985.
You can do:

select TO_DATE('01/01/1985','MM-DD-YYYY') + 6616 from dual;

TO_DATE('

Regards,

                                                                Isa

"KW" <runamok_at_sbcglobal.net> escribió en el mensaje news:Jxx2a.897$tm7.72963271_at_newssvr21.news.prodigy.com...
> Hi,
>
> 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
> 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 Fri Feb 14 2003 - 16:11:22 CET