Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-01816

month may only be specified once

Cause

More than one month format code was listed in a date specification. Only one of the following month format codes may be specified in a date: MM, MON, MONTH.


Action

Remove all but one month format from the date specification.