ORA-01801: date format is too long for internal buffer
ORA-01801: date format is too long for internal buffer
Our application is running 24X7 in a customer place and they are facing this particular error at times. Then they need to restart the Database to resolve this error. In Application programmatically absolutely no issues regarding date formats.
DB version is 9.2.0.5.
Can anybody give inputs what could be the reason and what needs to be done.
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.
Reply With Quote
Bookmarks