Popular Posts

Thursday, 22 August 2013

ORA-01839: date not valid for month specified

1. Error Message: ORA-01839: date not valid for month specified

Cause of Error


You tried to enter a date value, but you specified an invalid day value.


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


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