Previous Topic: -223 - A TIME STRING CANNOT CONTAIN MORE THAN ONE A: aaNext Topic: -225 - A TIME STRING CANNOT CONTAIN MORE THAN ONE BLANK BEFORE THE A OR P


-224 - A TIME STRING CANNOT CONTAIN MORE THAN ONE P: pp

Explanation

The DATE/TIME function is scanning a character string to determine its DATE/TIME format but has detected invalid characters (pp) 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.