Public bug reported: When I'm using java to read a time from MySQL: ResultSet r = (SQL query); ...... r.getTime("open_time").getTime() and this sentence gives different time (1 hour delta) on my server and my laptop (which got wrong time). The only difference between my server and laptop is timezone. When I changed timezone of my laptop from Asia/Chongqing to Asia/Shanghai as on the server, the time reads correctly. Then I used r.getTime("open_time").getTimezoneOffset() to check the timezone between Asia/Chongqing and Asia/Shanghai, it gives -420 and -480. In fact, the whole China is GMT+8, which means Asia/Chongqing and Asia/Shanghai should be the same time. Other java time functions don't have this problem.
Server: mysql-server 5.5.35-0ubuntu0.12.04.1 java version "1.7.0_51" OpenJDK Runtime Environment (IcedTea 2.4.4) (7u51-2.4.4-0ubuntu0.12.04.2) OpenJDK 64-Bit Server VM (build 24.45-b08, mixed mode) Laptop: mysql-server 5.5.35-0ubuntu0.13.10.2 java version "1.7.0_51" OpenJDK Runtime Environment (IcedTea 2.4.4) (7u51-2.4.4-0ubuntu0.13.10.1) OpenJDK 64-Bit Server VM (build 24.45-b08, mixed mode) ** Affects: openjdk-7 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1279792 Title: Wrong timezone offset given by java.sql.ResultSet.getTime() To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/openjdk-7/+bug/1279792/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs