Previous Topic: -226 - NO M AFTER THE A OR P OR TOO MANY COLONS IN A TIME STRINGNext Topic: -228 - TOO MANY NODES IN CHARACTER STRING: node count is n


-227 - THERE MUST BE AN M AFTER THE A OR P IN A TIME STRING

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 time which is 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.