Oracle database error code ORA-01818 – 'HH24' precludes use of meridian indicator

Oracle Database Error Code ORA-1818 Description :
'HH24' precludes use of meridian indicator
Error Cause:
A date specification contained both a 24-hour time format code and a meridian indicator code. If hours are specified using the 24-hour time format (HH24), a meridian indicator, AM or PM, may not be specified.

How to Solve :
Remove the meridian indicator format code, AM/PM or A.M./P.M., or the 24-hour time format code, HH24, from the date specification.


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