Oracle DB Error ORA-01820 format code cannot appear in date input format

The following is the cause of this error:

A date specification contained an invalid format code. Only the following may be specified when entering a date: year, month, day, hours, minutes, seconds, Julian day, A.M./P.M. and B.C./A.D.

Action you can take to resolve this issue: Remove the invalid format code from the date specification.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related