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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30086：间隔年 - 月结果不允许使用日期时间减法,
.原因：试图指定间隔年到月作为datetime减法的结果。,
.操作：由于此时间间隔类型的SQL标准中的规范不明确，因此目前不允许。将间隔类型更改为间隔天为second和resubmit语句。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题