Explanation
The DATE/TIME function is scanning a character string to determine its DATE/TIME format but has detected invalid characters in the string (xxxx). The query you issued probably contains a character string representation of a date, time, or TIMESTAMP in an invalid format. The function may read the character string as a time in USA (IBM USA Standard) format. See the CA Datacom/DB SQL User Guide for correct formats.
The SQLSTATE that equates to this SQL return code is 22007.
User Response
Ensure the character string in the query is the proper format.
|
Copyright © 2014 CA.
All rights reserved.
|
|