Informix - Problem description
Problem IT18610 | Status: Closed |
IFXPREPAREDSTATEMENT.SETTIMESTAMP SETS DATETIME YEAR TO MONTH COLUMN INCORRECTLY | |
product: | |
IBM JDBC / 5724I3501 / 410 - Informix 4.10 | |
Problem description: | |
With Informix JDBC, when using PreparedStatement.setTimestamp() to set a column defined as datetime year to month for a dynamic SQL statement, the data inserted into the column is incorrect. For example, if you want to insert '3000-01', the data inserted into the column is '2999-12'. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * JDBC 4.10 users prior to 4.10.JC9 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to JDBC 4.10.JC9 when available. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.12.2016 10.07.2017 10.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
4.10.JC9 | |
Problem solved according to the fixlist(s) of the following version(s) |