My Oracle Support Banner

DST Issue With JDBC Driver shows timestamp is one hour behind (Doc ID 1330228.1)

Last updated on AUGUST 09, 2023

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




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

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