Previous Topic: -199 - MONTH mm IS NOT BETWEEN 1 AND 12 INCLUSIVENext Topic: -201 - HOUR hh OUT OF RANGE


-200 - DAY dd OUT OF RANGE FOR MONTH mm, YEAR yy

Explanation

A date has been found to contain an invalid day. Either the day (dd) you supplied in the query is invalid or the result of the calculation used to determine the value is invalid. See the CA Datacom/DB SQL User Guide for DATE/TIME formats.

The SQLSTATE that equates to this SQL return code is 22008.

User Response

Correct the query to use a valid date or cause the calculation of a valid date.