we are using HXTT driver in our application to read mdb's and following are the details for the same,
driver jar name: Access_JDBC30.jar
dbutils:commons-dbutils-1.3.jar
my mdb queries are follows:
forearm_present:
Query = select count(*) > 0 from scananalysis a where TRIM(a.patient_key) = ? and a.scan_type IN ( 6, 7 )
Params = 1JTC080RFM0145063
Results = true
forearm_scanid:
Query = select trim(a.scanid) from scananalysis a where TRIM(a.patient_key) = ? and date(a.scan_date)= date(?) and a.scan_type IN ( 6, 7) order by a.scan_date desc
Params = 1JTC080RFM0145063,12/15/2010
Results = Null
forearm_maxdate:
Query = select max(a.scan_date) from scananalysis a where TRIM(a.patient_key) = ? and a.scan_type IN ( 6, 7 )
Params = 1JTC080RFM0145063
Results = 2009-12-22 10:43:55.0
dxa_date_forarm:
Query = select if(?,if(isnull(?),?,?),null);
Params: hip_present,hip_scanid,hip_maxdate,acquisition_date
(true, null, '2009-12-22 10:43:55.0' ,'12/15/2010')
result: '2009-12-22 05:13:55.0; instead of '2009-12-22 10:43:55.0'
i am getting the result for above query expression result as
HR:Min: 5:30 backward time
Could you please suggest me the right solution for this?
|
Try timezone connection property
For instance,
timezone=gmt
timezone=local
|
Could you please give the example how to add the timezone connection property
in the query?
|
It's a connection property,
1. you can use it in jdbc url, for instance, jdbc:dbf:/d:/test/dbf?timezone=local
2. use it in property objerct
properties.put("timezone","gmt");
Connection con=DriverManager.getConnection(jdbcurl,properties);
|
Main
webmaster@hxtt.com