The below error was due to non -valid date for birth date of participant in table. While I convert those dates into century am getting the below error

ORA-01801: date format is too long for internal buffer

The Code I used is TO_CHAR (p.birth_date, 'CC') NOT IN ('18','19','20','21'), to check whether dates are falling into given century.

When below dates cant able to convert into century format using above to_char function, here century is ‘100’ but the to_char can have capable to handle only 2 digit for century.



Below are the lists of participant having issue


PART_ID BIRTH_DATE YYYY-MM-DD

211379396 12/31/99 9999-12-31
238335183 12/31/99 9999-12-31
239264421 12/31/99 9999-12-31
238951412 12/31/99 9999-12-31

Solution : need to update the date field with valid date