Oracle DB Error ORA-30086 interval year-month result not allowed for datetime subtraction

Oracle DB Error ORA-30086 interval year-month result not allowed for datetime subtraction

The following is the cause of this error:

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

Action you can take to resolve this issue: 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.


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution