Re: Julian date conversion

Could it be that YYDDD type of julian? Try

to_char( to_date( strt, 'RRDDD' ), 'yyyy mm dd' )

 to see.

"Jeff Y. Y." <yuanjeff_at_yahoo.com> wrote in message news:a2bc9497.0204121053.755a223e_at_posting.google.com...
> There is a table column in NUMBER(6) type that stores a date in Julian
> format (I believe). I need convert it to a regular date, but can not
> get the right YYYY. Could you please tell me what algorithm I should
> use to get the right result?
>
> Thanks a lot.
>
> ---------------------------------------------------------------
> SQL> select to_char(to_date(strt, 'J'), 'MM-DD-YYYY') "real",
> 2 to_date(strt, 'dd/mm/yy') "wrong",
> 3 strt
> 4 from my_table where rownum < 10;
>
> real wrong STRT
> ---------- --------- ----------
> 08-11-4436 10-OCT-32 101032
> 11-10-4436 10-NOV-23 101123
> 11-10-4436 10-NOV-23 101123
> 11-19-4436 10-NOV-32 101132
> 11-21-4436 10-NOV-34 101134
> 11-21-4436 10-NOV-34 101134
> 12-02-4436 10-NOV-45 101145
> 12-12-4436 10-NOV-55 101155
> 12-19-4436 10-NOV-62 101162
Received on Fri Apr 12 2002 - 17:03:50 CDT