Oracle 6 digit date ?

[James Clarke]

Hi,

I came accross a date format defined as number(6,0) used in a JD Edwards database.

A number such as 104147 is apparently year 2004, 147th year...

Does Oracle 8i have a function that can convert this to date type ?

thanks in advance,

J.C

[Chris Hendy]

No, you would have to write your own.

By the way, do you not mean 104147 is year 2004, 147th day?

If so, you would do something like

TO_DATE(TO_CHAR(1900000+v_jd_date),'YYYYDDD')

where v_jd_date is your JD Edwards date-as-a-number

[ November 11, 2006: Message edited by: Chris Hendy ]
[ November 11, 2006: Message edited by: Chris Hendy ]