tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

Oracle/PLSQL: ORA-01843

Learn the cause and how to resolve the ORA-01843 error message in Oracle.

Description

When you encounter an ORA-01843 error, the following error message will appear:

  • ORA-01843: not a valid month

Cause

You entered a date, but the month portion of the date was not a valid month.

Resolution

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

Option #1

Re-enter the date value using either a MONTH format mask.

The valid values for month are:

  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December

Or you could use the MON format mask and use one of the following values:

  • Jan
  • Feb
  • Mar
  • Apr
  • May
  • Jun
  • Jul
  • Aug
  • Sep
  • Oct
  • Nov
  • Dec

If all else fails, you may want to consider using the TO_DATE function and specifying the date format mask.