Oracle Error OCI-01870: the intervals or datetimes were not mutually comparable

Oracle Error Message

OCI-01870: the intervals or datetimes were not mutually comparable

Reason for the Error

The intervals or datetimes are not mutually comparable.

Solution

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