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 to [Release 11.2 to 12.1]
Information in this document applies to any platform.


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 JDBC driver and an 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.


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

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.