Oracle database error code ORA-01820 – format code cannot appear in date input format

Oracle Database Error Code ORA-1820 Description :
format code cannot appear in date input format
Error Cause:
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.

How to Solve :
Remove the invalid format code from the date specification.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»