ORA-01870: the intervals or datetimes are not mutually
comparable



ORA-01870: the intervals or datetimes are not mutually comparable..

Answer / guest

Cause: The intervals or datetimes are not mutually comparable.

Action: Specify a pair of intervals or datetimes that are
mutually comparable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Oracle Errors Interview Questions

ORA-15051: file 'string' contains string error(s)

1 Answers  


PCC-00119: Value of const variable in INTO clause will be modified

1 Answers  


ORA-28654: table and partition not overflow compatible

1 Answers  


DRG-13004: language is invalid

1 Answers  


ORA-13269: internal error [string] encountered when processing geometry table

1 Answers  






ORA-12800: system appears too busy for parallel query execution

1 Answers  


SQL-02106: Inconsistent cursor cache. Invalid Oracle cursor number

1 Answers  


ORA-30353: expression not supported for query rewrite

1 Answers  


ORA-07303: ksmcsg: illegal database buffer size.

1 Answers  


ORA-06018: NETASY: message send failure

1 Answers  


DRG-11803: OK

1 Answers  


ORA-08187: snapshot expression not allowed here

1 Answers  


Categories