Database Error Messages

ORA-01846

not a valid day of the week

Cause

A date specified an invalid day of the week. Valid days are:

  • Monday-Sunday, for format code DAY
  • Mon-Sun, for format code DY
  • 1-7, for format code D

Action

Enter a valid day of the week value in the correct format.