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

PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1

1 Answers  


ORA-32639: Aggregate functions on reference MODELs are not allowed

1 Answers  


PCC-02317: illegal cast type expression

1 Answers  


ORA-18009: one or more outline system tables do not exist

1 Answers  


ORA-09924: Can't spawn process - core dump directory not created properly

1 Answers  


LPX-00272: FTP server unavailable: ~s

1 Answers  


KUP-11010: unable to open at least one dump file for load

1 Answers  


ORA-07406: slbtpd: invalid number.

1 Answers  


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

1 Answers  


ORA-22603: cannot add an attribute to the already generated TDS handle

1 Answers  


PCC-00135: Result Set Cursor usage is not standard SQL

1 Answers  


ORA-01979: missing or invalid password for role 'string'

1 Answers  


Categories