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

Teradata Database Messages

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

9104 Invalid Period arithmetic operation. %VSTR


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.


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