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
