Oracle / PLSQL: ORA-01839 Error Message
Learn the cause and how to resolve the ORA-01839 error message in Oracle.
Description When you encounter an ORA-01839 error, the following error message will appear: ORA-01839: date not valid for month specified
Cause You tried to enter a date value, but you specified an invalid day value.
Resolution how to resolve this Oracle error are:
Option No. 1 Check your DD value (ie: day of the month).
This value must be between 1 and the number of days in the month.
January - 1 to 31
February - 1 to 28 (1 to 29, if a leap year)
March - 1 to 31
April - 1 to 30
May - 1 to 31
June - 1 to 30
July - 1 to 31
August - 1 to 31
September - 1 to 30
October - 1 to 31
November - 1 to 30
December - 1 to 31
No comments:
Post a Comment