15.00 - 2666 Invalid date supplied for %TVMID.%FLDID. - Teradata Database

Teradata Database Messages

Teradata Database
Release Number
English (United States)
Last Update

2666 Invalid date supplied for %TVMID.%FLDID.


This error occurs when an operation is attempted on an invalid date and a known data field is involved.

Generated By:

AMP Steps.

For Whom:

End User.


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 DATE data type. This error can also occur when character strings are being converted to DATE type and the character data is in the wrong format or conversion results in an invalid value. This is the same error as 2665, except that Tvmid and Fldid are available. The TvmId and FldId can be from the source or target row.


Correct and resubmit the request.