HPE NonStop SQL/MX Error – 3158 The DATETIME value value is not valid.

In this blog post, let’s learn about the error message “3158 The DATETIME value value is not valid.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3158 The DATETIME value value is not valid.

Reason for the Error

You specified an invalid DATETIME literal. Either the DATETIME qualifier has an invalid combination of start and end fields or the DATETIME literal string is invalid.

Solution

Specify a valid DATETIME literal and resubmit