With Oracle JDBC Driver 11.2.0.1, 11.2.0.3 Date Value Is Getting 1 Hour Extra Added While Fetching
(Doc ID 1947435.1)
Last updated on FEBRUARY 20, 2021
Applies to:
JDBC - Version 11.2.0.3.0 and laterInformation in this document applies to any platform.
Goal
With the Oracle JDBC drivers version 11.2.0.1 and 11.2.0.3, the date value is getting 1 hour extra added while fetching and inserting into another database. Only dates within the DST range are being affected.
For example:
Source Date: '03/11/2012 2:07:00' -- This comes under DST and hence 1 hour getting added extra
Target Date : '03/11/2012 3:07:00'
Source Date :'04/05/2003 2:45:00' -- This doesn't come under DST and hence DATE in target is correct.
Target Date : '04/05/2003 2:45:00'
Solution
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
Goal |
Solution |
References |