15.00 - 9104 Invalid Period arithmetic operation. %VSTR - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

9104 Invalid Period arithmetic operation. %VSTR

Explanation:

An error was generated during Period arithmetic operation. The exact message is given within VSTR. a) For arithmetic operation where one operand has PERIOD(TIME) and the other operand is an interval, the result beginning bound must be less than the result ending bound. For example, this can occur when adding or subtracting an interval that causes one element of the result to go past 24 hours and be modulo 24 hours but the other element of the result does not. b) For period of element type DATE/TIMESTAMP the resulting ending bound value of a period arithmetic operation must not be equal to the UNTIL_CHANGED value.

Generated By:

Period constructor function.

For Whom:

End User.

Remedy:

Correct the Period arithmetic expression/bound values and re-submit.