Wrong Time Inserted into Table after IBM JDK Timezone Updates Applied

(Doc ID 2217995.1)

Last updated on JANUARY 03, 2017

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


With JDBC 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