Previous Topic: -224 - A TIME STRING CANNOT CONTAIN MORE THAN ONE P: ppNext Topic: -226 - NO M AFTER THE A OR P OR TOO MANY COLONS IN A TIME STRING


-225 - A TIME STRING CANNOT CONTAIN MORE THAN ONE BLANK BEFORE THE A OR P

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.