日期在Linux与Windows下的区别

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

最近遇到了这个问题，就是相同的代码在Windows与Linux下的日期转换不一致。

原因：时区问题，主要是操作系统与JVM中的时区不同导致的

在网上查了很多处理的方法：最后总结出一条简单粗暴的方法；原理很简单，就是将要转换的日期转换成“GMT+8”，然后统一转换成String，再将String统一转换成时间戳，这样相应的时间差就不变了。

     public MonitorBean findByCity(String city) {

         int code = -1;

         SimpleDateFormat formatter = new SimpleDateFormat("yyMMdd"); // 规定日期格式

         formatter.setTimeZone(TimeZone.getTimeZone("GMT+8"));

         String tableName = "shop_queue_" + formatter.format(new Date());

         String sql = "select crawled_at from " + tableName + " where city = \"" + city + "\"" + " order by id desc limit 1;";

         try {

             Connection connection = dataSource.getConnection();

             Statement statement = connection.createStatement();

             ResultSet resultSet = statement.executeQuery(sql);

             if (resultSet.next()) {

                 Timestamp timestamp = resultSet.getTimestamp(1);

                 String timestampString = timestamp.toString().substring(0,timestamp.toString().length()-2);

                 SimpleDateFormat formatNowTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); // 规定日期格式

                 formatNowTime.setTimeZone(TimeZone.getTimeZone("GMT+8"));

                 String nowTimeString = formatNowTime.format(new Date());

                 try{

                     long timeStamp = formatNowTime.parse(timestampString).getTime();

                     long nowTime = formatNowTime.parse(nowTimeString).getTime();

                     long value =  nowTime - timeStamp;

                     if (value < Integer.valueOf(MAX_MIN) * 60 * 1000) {

                         code = 100;

                     }else {

                         code = 200;

                     }

                 }catch (Exception e){

                     e.printStackTrace();

                     MonitorBean monitorBean = new MonitorBean(city, "-1", e.getMessage());

                     return monitorBean;

                 }

             }

             resultSet.close();

             connection.close();

             if(code > 0){

                 return new MonitorBean(city, String.valueOf(code), city+"超出" + MAX_MIN + "分钟无数据");

             }else{

                 return new MonitorBean(city, String.valueOf(code), city+"无数据");

             }

         } catch (SQLException e) {

             e.printStackTrace();

             MonitorBean monitorBean = new MonitorBean(city, "-1", e.getMessage());

             return monitorBean;

         }

     }