SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert julian date in Oracle SQL null

3604109Dec 14 2017 — edited Dec 15 2017

I want to convert Julian dates to normal dates (from JDE database). I run this query:

select to_date(to_char((DATE+1900000)),'YYYYDDD') from table ;

And I get the following error:

ORA-01848: day of year must be between 1 and 365 (366 for leap year).

I know it's because some dates are null or have no values.

Can anyone help me out on this please?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2018

Added on Dec 14 2017

#date

15 comments

4,202 views