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!

Getting error: ORA-01841: (full) year must be between -4713 and 9999, and not be 0

Christine1111Apr 1 2015 — edited Apr 2 2015

Hi - I'm getting error ORA-01841 ((full) year must be between -4713 and 9999, and not be 0) due to the following line in my where clause:

AND  p_run_date < nvl((add_months(ip.insured_plan_termination_date,13)),to_date('31-DEC-9999','DD-MON-YYYY'))

I've search and everything I've read talks about not comparing strings with dates, but that's not happening here. p_run_date is definitely a date. I've even hardcoded in a specific date and I still get the error.

Any help is greatly appreciated.

Thanks,

Christine

This post has been answered by Frank Kulash on Apr 1 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2015

Added on Apr 1 2015

12 comments

9,267 views