How to fix the Oracle error ORA-30086: interval year-month result not allowed for datetime subtraction?

In this post, you’ll learn more about the Oracle ErrorORA-30086: interval year-month result not allowed for datetime subtraction with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-30086: interval year-month result not allowed for datetime subtraction

Reason for the Error ORA-30086: interval year-month result not allowed for datetime subtraction

An attempt was made to specify interval year to month as the result of datetime subtraction.

How to fix the Error ORA-30086: interval year-month result not allowed for datetime subtraction ?

You can fix this error in Oracle by following the below steps

This is not allowed currently due to unclear specification in SQL Standards for this interval type. Change the interval type to interval day to second and resubmit statement.