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 colons 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. 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.
|
|