Saturday 19 May 2012

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

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.

No comments:

Post a Comment