totn Oracle Error Messages

Oracle / PLSQL: ORA-01846 Error Message

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

Description

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

  • ORA-01846: not a valid day of the week

Cause

You tried to enter a date value, but you specified a day of the week that is not valid.

Resolution

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

Option #1

Enter a valid day of the week.

  • For the D format code, 1-7 are valid values.
  • For the DAY format code, Sunday-Saturday are valid values.
  • For the DD format code, 1-31 are valid values.
  • For the DDD format code, 1-366 are valid values.
  • For the DY format code, Sun-Sat are valid values.

Learn more about the TO_DATE function.