time always less 8 hous when perform insert or update |
Gib Hsu |
2009-10-23 19:54:34 |
Hi Support,
I am using a simple update by using jdbc40 driver.
However, the value has been always minus 8 hours in the records.
May I know what is the root cause?
update ptm_User set last_login_time=Date() where uid='gib hsu';
|
Re:time always less 8 hous when perform insert or update |
HXTT Support |
2009-10-25 02:24:09 |
>update ptm_User set last_login_time=Date() where uid='gib hsu';
Timezone offset. You can try PreparedStatement.setDate(int parameterIndex,Date x,Calendar cal).
|
Re:Re:time always less 8 hous when perform insert or update |
Gib Hsu |
2009-10-25 19:23:43 |
Hi Support,
I am using iBatis framework and map the java Date format to timestamp is iBatis SqlMap. How can I config it to solve the timezone offset?
|
Re:Re:Re:time always less 8 hous when perform insert or update |
Gib Hsu |
2009-10-26 00:20:20 |
Hi Support,
I am using Eclipse database explore and face the problem. Is that any driver can fix the problem?
|
Re:Re:Re:Re:time always less 8 hous when perform insert or update |
HXTT Support |
2009-10-27 06:34:47 |
Please download the latest pacakge.
|
Re:time always less 8 hous when perform insert or update |
Gib Hsu |
2009-10-27 18:15:17 |
Hi Support, I just tested the latest driver by using the SQL below.
select Date(), Now(), MILLISECOND(Now()) from ptm_User
The current time is 2009-10-28 10:12:51.185. However, the Now() still shows
2009-10-28 02:12:51.185 which is still 8 hours less.
The Date() is correct now.
|
Re:Re:Re:Re:Re:Re:time always less 8 hous when perform insert or update |
HXTT Support |
2009-11-01 04:07:16 |
Please download the latest package now.
|
Re:time always less 8 hous when perform insert or update |
Gib Hsu |
2009-11-05 18:24:32 |
Hi Support,
I downloaded the latest driver. When I did the selecy Now(), the value is correct.
But when I did a update, the value from database is still 8 hour less. Can you check it?
--2009-11-06 10:21:39.426 (current value)
select Now() from ptm_Trial_Lot_Detl;
--2009-11-06 02:21:53 (value in the cloumn)
update ptm_Trial_Lot_Detl set Div_Start_RD=Now();
select Div_Start_RD from ptm_Trial_Lot_Detl
|
Re:Re:Re:Re:Re:Re:Re:Re:time always less 8 hous when perform insert or update |
HXTT Support |
2009-11-05 19:15:16 |
Passed test. Maybe you haven't download the latest package v3.2.103.
select Now() from ptm_User;
2009-11-06 11:13:13.328
The total row number of resultset: 1
1:update ptm_User set last_login_time=Now();
1:1
select last_login_time from ptm_User
2009-11-06 11:13:13.437
The total row number of resultset: 1
|