Wrong Time Inserted into Table after IBM JDK Timezone Updates Applied
(Doc ID 2217995.1)
Last updated on OCTOBER 08, 2022
Applies to:
JDBC - Version 11.1.0.7 and laterInformation in this document applies to any platform.
Symptoms
With JDBC 11.1.0.7 and IBM JDK 1.6 (installed tzdata2016i), after application sets a timestamp data to value "2014-03-14 23:59:01":
- Application gets the same value "2014-03-14 23:59:01".
- Sqlplus gets value "2014-03-15 00:00:59"
- to_char function gets value "00000000000000".
- dump value is "120,114,3,15,1,1,198"
Changes
Installation of IBM JDK time zone updates tzdata2016i.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |