HPE NonStop SQL/MX Error – 4036 The source field of the EXTRACT function must be of DateTime or Interval type.

In this blog post, let’s learn about the error message “4036 The source field of the EXTRACT function must be of DateTime or Interval type.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4036 The source field of the EXTRACT function must be of DateTime or Interval type.

Reason for the Error

You specified a source field of the EXTRACT function that is not a DATETIME or INTERVAL data type.

Solution

Correct the source field type and resubmit