Ganesh Dudhade: Date columns in SQL-Server 2008 (sqljdbc4.jar ) running under Java 1.8 retrieved as 2 days in the past.

Tuesday, 22 November 2016

Hi All,

Today(22/11/2016,Tue) I have faced one issue regarding jdbc driver.

I was using jdk 1.8 and sqljdbc4.jar on SQL-Server 2008 .

In my database column datatype is DateTime2 which contain '2016-03-31 00:00:00' value

when I fired query from sql qeury browser then records retrived correctly.

when retrived using jdbc driver then I was getting '2016-03-26 00:00:00'

For resolving above issue I have replaced sqljdbc4.jar by sqljdbc42.jar and its working fine.

Thank you.