My Oracle Support Banner

Wrong Time Inserted into Table after IBM JDK Timezone Updates Applied (Doc ID 2217995.1)

Last updated on NOVEMBER 03, 2023

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.