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

The option(s) to resolve this Oracle error are:

Option #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