Teradata Database Message 6980 - 6980 - Analytics Database - Teradata Vantage

Message

Invalid CAST. Casting the specified source value as PERIOD is not allowed.

Explanation

Only a CHARACTER, VARCHAR, PERIOD, DATE, TIME, or TIMESTAMP value can be cast as a Period data type. Using the CAST function for casting a value of any other data type is not allowed. Note that a PERIOD(DATE) or DATE value cannot be cast as PERIOD(TIME). Also, a PERIOD(TIME) or TIME value cannot be cast as PERIOD(DATE).

Generated By

Parser.

For Whom

End User.

Notes

None

Remedy

Rewrite the statement by correcting the source value to have a data type such that it is valid to cast the source value as the specified target type and re-submit.