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.
No comments:
Post a Comment