My Oracle Support Banner

Possible Wrong Timestamp Information When Oracle Server and JDK Have Conflicting Timezone Information (Doc ID 1941076.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 11.2.0.1.0 to 12.1.0.2.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When inserting timestamps into the database, the timestamp information may be incorrect during occasions when there is a time change, such as Daylight Savings Time (DST). The problem occurs during the hour that is repeated after moving the clock back (for example, between 1 AM and 2 AM).

For example, given an 11.2.0.4 JDBC driver and an 11.2.0.4 database:

In the database, the value for a timestamp column is 1924-03-30 00:00:00.
When writing the same value through JDBC, it is written as 1924-03-29 23:00:00.

In other words, the values differ by an hour.

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.