从 SQL 数据库读取的日期在另一台机器上似乎不同

发布于 2025-01-08 05:52:12 字数 393 浏览 0 评论 0原文

我遇到了一个非常奇怪的情况。我使用 Eclipse 连接到远程 SQL Server 2008 数据库，并获得了正确的日期。但是当我的同事复制代码并运行它时，所有日期都比应有的日期早了 2 天。例如，我得到 2011-02-22，他得到 2011-02-20。

非常感谢！

String test = "select * from Readings";
ResultSet set = state.executeQuery(test);
while (set.next()) {
    String row="";for(int i=1;i<10;i++){
        row += set.getString(i) + ",";
        arr.add(row);
    }
}

原文

I have meet a very weird situation. I use Eclipse to connect to a remote SQL Server 2008 database, and I get the correct date. But when my colleague copies the code and runs it, all the dates are 2 days earlier than they should be. For example, I get 2011-02-22 and he gets 2011-02-20.

A lot of thanks!

String test = "select * from Readings";
ResultSet set = state.executeQuery(test);
while (set.next()) {
    String row="";for(int i=1;i<10;i++){
        row += set.getString(i) + ",";
        arr.add(row);
    }
}

分享到QQ

分享到微博