Explanation
A time has been found to contain an invalid microsecond value. Either the time you supplied in the query is invalid or the result of the calculation used to determine the time value is invalid. Microseconds (ssssss) is a 6-digit column with each two digits representing a fraction of microseconds. One of these fractional parts is greater than 99. The value of each fractional part must be between 0 and 99 inclusive. 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 time or cause the calculation of a valid time value.
|
Copyright © 2014 CA.
All rights reserved.
|
|