Learn the reason and how to get to the bottom of 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 certain a day of the week that is now 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 layout code, Sunday-Saturday are valid values. For the DD structure code, 1-31 are legitimate values. For the DDD structure code, 1-366 are valid values. For the DY layout code, Sun-Sat are valid values.
Learn more about the TO_DATE function.