DST Issue With JDBC Driver shows timestamp is one hour behind

(Doc ID 1330228.1)

Last updated on MARCH 08, 2017

Applies to:

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


While using Oracle's JDBC Driver it appears that when Day Light Saving Time (DST) happens and the date-time/timestamp passed to the database using JDBC it subtracts 1 hour from the timestamp passed by the client to the database.
For example, on March-11-2012 at 3:20AM (after spring forward) if JAVA client sends the timestamp (11-Mar-2012 03:20:00 AM) to the database, the timestamp inserted into the table is one hour less (11-Mar-2012 02:20:00 AM).

This issue does not reproduce with JDBC, or


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