1.为什么不同时区毫秒相减得0 ?
long dif = cal2.getTimeInMillis() - cal1.getTimeInMillis();
2.Calendar cJapan = new GregorianCalendar(TimeZone.getTimeZone("Japan"));
Timestamp tJapan = new Timestamp(cJapan.getTimeInMillis());
String sql = "insert into message values (null, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setTimestamp(1, tJapan);
pstmt.executeUpdate();
数据库里依然是本地时间,为什么?
long dif = cal2.getTimeInMillis() - cal1.getTimeInMillis();
2.Calendar cJapan = new GregorianCalendar(TimeZone.getTimeZone("Japan"));
Timestamp tJapan = new Timestamp(cJapan.getTimeInMillis());
String sql = "insert into message values (null, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setTimestamp(1, tJapan);
pstmt.executeUpdate();
数据库里依然是本地时间,为什么?
long dif = cal2.getTimeInMillis() - cal1.getTimeInMillis();
这个值是1970 年 1 月 1 日 00:00:00 GMT 以来经过的毫秒数,它跟时区没关系,是绝对值所以想等。