15.00 - 5326 Operand of EXTRACT function is not a valid data type or value. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

5326 Operand of EXTRACT function is not a valid data type or value.

Explanation:

The argument of EXTRACT must be an appropriate DateTime type or for a Time field, may be a REAL value, but the value must be in the appropriate range for TIME stored in a REAL value.

Generated By:

Optimizer or Evl procedures.

For Whom:

End User.

Remedy:

Check the data type of the operand. If the data type is REAL and a time field is being extracted, check that the column or source involved contains Time values.