With Oracle JDBC Driver 220.127.116.11, 18.104.22.168 Date Value Is Getting 1 Hour Extra Added While Fetching
Last updated on DECEMBER 10, 2014
Applies to:JDBC - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
With the Oracle JDBC drivers version 126.96.36.199 and 188.8.131.52, 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.
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'
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