Oracle database error code ORA-30086 – interval year-month result not allowed for datetime subtraction

Oracle Database Error Code ORA-30086 Description :
interval year-month result not allowed for datetime subtraction
Error Cause:
An attempt was made to specify interval year to month as the result of datetime subtraction.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»