Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
time always less 8 hous when perform insert or update
Gib Hsu
2009-10-23 19:54:34.0
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.0
>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.0
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.0
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.0
Please download the latest pacakge.
Re:time always less 8 hous when perform insert or update
Gib Hsu
2009-10-27 18:15:17.0
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.0
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.0
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.0
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

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap