Explanation
The DATE/TIME function is scanning a character string to determine its DATE/TIME format but has detected invalid characters in the string. n represents the number of periods found in the character string. The query you issued probably contains a character string representation of a date, time, or TIMESTAMP in an invalid format. For correct formats, see the CA Datacom/DB SQL User Guide.
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.
|
|