Wrong Time Inserted into Table after IBM JDK Timezone Updates Applied
Last updated on JANUARY 03, 2017
Applies to:JDBC - Version 220.127.116.11 and later
Information in this document applies to any platform.
With JDBC 18.104.22.168 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"
Installation of IBM JDK time zone updates tzdata2016i.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms