Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PLS-00717: method 'string' does not have matching signature among existing methods

1 Answers  


QSM-01063: query has a dictionary table or view

1 Answers  


ORA-22893: constraint can be specified only for REF columns

1 Answers  


ORA-19202: Error occurred in XML processingstring

1 Answers  


ORA-01115: IO error reading block from file string (block # string)

1 Answers  






ORA-31632: master table "string.string" not found, invalid, or inaccessible

1 Answers  


ORA-22922: nonexistent LOB value

1 Answers  


ORA-12560: TNS:protocol adapter error

1 Answers  


ORA-24092: invalid value string specified

1 Answers  


ORA-29263: HTTP protocol error

1 Answers  


ORA-14069: invalid TABLESPACE_NUMBER value

1 Answers  


ORA-19862: backup pieces must be validated before accessing results

1 Answers  






Categories