Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-30086: interval year-month result not allowed for datetime subtraction
Oracle® Database Error ORA-30086453/19

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

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

Action: 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.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle