Right now the back end of our application is oracle 7.3.4. Our
application uses Julian dates that are stored in the database
and char(6) in the format yy0ddd, where 0 is a delimiter between
yy and ddd.
When we display this julian date on the front end, we use to
to_date function to convert it to yyyy-mm-dd format as specified
in the nls_date_format parameter.
Select to_date(<6char julian dat>,'rr#ddd') from <Table Name>;
This works fine in Oracle 7.3.4.
Now we are migrating our database to oracle 8i. When we were
doing preliminary testing we found that the above select
statement is resulting in Ora - 01861.
Could anyone please let me know as to why this would be
happening.
Thanks
Vaidya