In this blog post, let’s learn about the error message “4231 The first operand of function func-name must be either numeric or datetime.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4231 The first operand of function func-name must be either numeric or datetime.
Reason for the Error
The first operand specified for function name was not numeric or datetime.
Solution
Specify either numeric or datetime first operand, and resubmit the statement