Previous Topic: -198 - YEAR yy IS LARGER THAN 99Next Topic: -200 - DAY dd OUT OF RANGE FOR MONTH mm, YEAR yy


-199 - MONTH mm IS NOT BETWEEN 1 AND 12 INCLUSIVE

Explanation

A date has been found to contain an invalid month. mm represents the hexadecimal data type value. A valid value for the month is any integer greater than zero and less than 13. Either the date you supplied in the query is out of this range or the result of the calculation used to determine the value is out of this range. 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.