dms2000 | 2010-05-21 09:41:03.0 | |
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 | ||
HXTT Support | 2010-05-24 03:57:44.0 | |
>The driver always saves the date as GMT.
Changed again:( Please download the latest package. |