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 11.1.0.7 and later
Information 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

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