PLS-00166: bad format for date, time or timestamp literal



PLS-00166: bad format for date, time or timestamp literal..

Answer / guest

Cause: The contents of the date, time or timestamp literal
did not match the expected format 'yyyy-mm-dd
hh24:mi:ssxfftzh:tzm'.

Action: Use a correctly-formatted datetime literal.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02332: cannot create index on attributes of this column

1 Answers  


DRG-11427: valid gist level values are string

1 Answers  


LSX-00259: invalid character found in the pattern

1 Answers  


PLS-00661: RETURN statement in a CONSTRUCTOR cannot include an expression

1 Answers  


ORA-02157: no options specified for ALTER USER

1 Answers  






LPX-00659: Output write failed.

1 Answers  


ORA-24900: invalid or unsupported mode paramater passed in call

1 Answers  


ORA-12527: TNS:listener: all instances are in restricted mode or blocking new connections

1 Answers  


ORA-10654: Table is of type temporary or external

1 Answers  


ORA-28012: Manual commit not allowed here

1 Answers  


IMP-00087: Problem with internal hash table of schema/table names

1 Answers  


NID-00123: Magic number for datafile "string" is incorrect

1 Answers  


Categories