When using bulk insert from sqlserver to access (accesspstmt.setObject(1, sqlserverRs)) with also setting timezone property to GMT on access connection ( props.setProperty("timezone", "local")) we noticed that 2010-03-14 02:00:00 is exported with one extra hour (2010-03-14 03:00:00 ).
The JVM's timezone is (UTC-05:00) Eastern Time (US & Canada) but I was assuming it won;t matter since i set GMT on connection props.
Is there a workaround for this issue?
Thanks,
Laura
|
>but I was assuming it won;t matter since i set GMT on connection props.
For GMT, you should use props.setProperty("timezone", "GMT")
|
From a previous post, I was advised to use local...
Here is the link http://www.hxtt.com/support_view_issue.jsp?product=access&id=1266916197
|
|
Maybe it's resulted by SQL Server's time zone offset. You can try props.setProperty("timezone", "GMT-6")
|
Main
webmaster@hxtt.com