15.00 - 6979 Invalid CAST. Casting a Period value as the specified target type is not allowed. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

6979 Invalid CAST. Casting a Period value as the specified target type is not allowed.

Explanation:

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

Generated By:

Parser modules.

For Whom:

End User.

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.