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
