Teradata Database Message 9842 - 9842 - Analytics Database - Teradata Vantage

Message

The DateTime expression specified in FOR PORTION OF must be comparable to the data type of the start column of the ValidTime period.

Explanation

If FOR PORTION OF is specified in the update or delete operation then the data type of the DateTime expression in the FOR PORTION OF must be comparable with the data type of the start column of the ValidTime period.

Generated By

RES modules.

For Whom

The end user.

Notes

None

Remedy

Rewrite the DateTime expression such that it results into comparable data type of the start column of the ValidTime period and resubmit.