Previous Topic: -227 - THERE MUST BE AN M AFTER THE A OR P IN A TIME STRINGNext Topic: -229 - TOO MANY DIGITS PER NODE IN STRING: xxxx


-228 - TOO MANY NODES IN CHARACTER STRING: node count is n

Explanation

The DATE/TIME function is scanning a character string to determine its DATE/TIME format but has detected invalid characters in the string. The query you issued probably contains a character string representation of a date, time, or TIMESTAMP in an invalid format. n represents the number of nodes. 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.