Hi
The driver always saves the date as GMT. How can I return or save the local date.
Code:
TimeZone newZone = TimeZone.getTimeZone("GMT+2");
TimeZone.setDefault(newZone);
Calendar calendar = Calendar.getInstance();
java.sql.Timestamp date1 = new java.sql.Timestamp(calendar.getTime().getTime());
System.out.println("Date1: "+date1);
System.out.println(calendar.getTimeZone());
Class.forName("com.hxtt.sql.dbf.DBFDriver");
String jdbcConnection = "jdbc:dbf:/d:/dms2000/data/dms";
String sql = "select * from hxtt" ;
Properties props = new Properties();
props.setProperty("timezone","local");
Connection conn = DriverManager.getConnection("jdbc:dbf:/d:/dms2000/data/dms?lockType=DBASE4BDE",props);
PreparedStatement ps = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ps.executeQuery();
ResultSet rs = ps.getResultSet();
if(rs.next()){
rs.updateTimestamp("TIMESTAMP1", date1);
rs.updateRow();
rs.first();
System.out.println("Return: "+rs.getObject("TIMESTAMP1"));
}
rs.close();
Results;
Date1: 2010-05-21 18:31:25.56
sun.util.calendar.ZoneInfo[id="GMT+02:00",offset=7200000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]
Return: 2010-05-21 16:31:25.56
|
>The driver always saves the date as GMT.
Changed again:( Please download the latest package.
|