Teradata Database Message 5327 - 17.10 - 5327 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
ADD_MONTHS has been called with wrong data types or values.
Explanation
The first argument of ADD_MONTHS must be of the TDBS DATE Type, and the second argument must be a BYTEINT,SMALLINT or INTEGER. The values of the first argument, DATE, and the second, MONTHS, must be in ranges such that the resulting date has a Year value between 0000 and 3500.
Generated By
Optimizer or Evl procedures.
For Whom
End User.
Notes
None
Remedy
Use values of proper types and ranges.