Teradata Database Message 2665 - 2665 - Analytics Database - Teradata Vantage

Message

Invalid date.

Explanation

This error occurs when date arithmetic is attempted on an invalid date.

Generated By

AMP Steps.

For Whom

End User.

Notes

Dates are stored as integers in the form YYMMDD, where YY is a calendar year beginning with 1900. Values such as 861332 are invalid as dates and may not be used where the value is to be used as a DATE data type. This error can also occur when character strings are being converted to DATE and the character data is in the wrong format or conversion results in an invalid value.

Remedy

Correct and resubmit the request.