Teradata Database Message 2665 - 17.10 - 2665 - 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
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.