15.00 - 5327 ADD_MONTHS has been called with wrong data types or values. - 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)

5327 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.

Remedy:

Use values of proper types and ranges.