- Java 双重比较
- java - 比较器与 Apache BeanComparator
- Objective-C 完成 block 导致额外的方法调用?
- database - RESTful URI 是否应该公开数据库主键?
我遇到了 Joda 问题,我认为这可能是一个错误。然而,我很可能在使用库时犯了错误,所以请给我你的反馈。
我们一直在生产中使用 joda 在我们的数据库存储格式 (UTC) 和用户的时区偏好之间转换时间。使用该系统的员工都在不遵守夏令时的亚利桑那州工作。除其他外,该系统跟踪全国体育赛事的开始时间。
Joda 对我们来说工作得很好,直到我们注意到在时间更改的前一天我们得到了一些不正确的结果。我们发现 joda 似乎在 UTC 午夜改为夏令时,而不是在特定时区的适当时间。此外,仅当将 DST 观察状态之间的时间转换为非 DST 状态(如亚利桑那州)时,才会出现此问题。
我制作了一个完整的测试用例来说明这个问题。正如您将看到的,joda 为所有 US/Eastern -> US/Pacific 测试用例提供了预期的结果。对于 US/Arizona -> US/Pacific,它在 11 月变化之前和之后的全年都有效。然而,在时间更改当天(11 月 6 日),时间不正确。行军时间的变化也可能存在问题,但我还没有对其进行详尽的测试。
这是所提供测试的输出(11 月 6 日的条目说明了错误):
=== November 1st, Expected Result (0 hour) ===
java:
Converting 2010-11-01 09:00 from US/Arizona to US/Pacific.
Result: 2010-11-01 09:00. Change (0 hour).
joda:
Converting 2010-11-01 09:00 from US/Arizona to US/Pacific.
Result: 2010-11-01 09:00. Change (0 hour).
=======================================
=== November 6th, Expected Result (0 hour) ===
java:
Converting 2010-11-06 09:00 from US/Arizona to US/Pacific.
Result: 2010-11-06 09:00. Change (0 hour).
joda:
Converting 2010-11-06 09:00 from US/Arizona to US/Pacific.
Result: 2010-11-06 08:00. Change (-1 hour).
=======================================
=== November 12th, Expected Result (-1 hour) ===
java:
Converting 2010-11-12 09:00 from US/Arizona to US/Pacific.
Result: 2010-11-12 08:00. Change (-1 hour).
joda:
Converting 2010-11-12 09:00 from US/Arizona to US/Pacific.
Result: 2010-11-12 08:00. Change (-1 hour).
=======================================
=== March 12th, Expected Result (-1 hour) ===
java:
Converting 2010-03-12 09:00 from US/Arizona to US/Pacific.
Result: 2010-03-12 08:00. Change (-1 hour).
joda:
Converting 2010-03-12 09:00 from US/Arizona to US/Pacific.
Result: 2010-03-12 08:00. Change (-1 hour).
=======================================
=== March 14th, Expected Result (0 hour) ===
java:
Converting 2010-03-14 09:00 from US/Arizona to US/Pacific.
Result: 2010-03-14 09:00. Change (0 hour).
joda:
Converting 2010-03-14 09:00 from US/Arizona to US/Pacific.
Result: 2010-03-14 09:00. Change (0 hour).
=======================================
=== November 1st, Expected Result (-3 hour) ===
java:
Converting 2010-11-01 09:00 from US/Eastern to US/Pacific.
Result: 2010-11-01 06:00. Change (-3 hour).
joda:
Converting 2010-11-01 09:00 from US/Eastern to US/Pacific.
Result: 2010-11-01 06:00. Change (-3 hour).
=======================================
=== November 6th, Expected Result (-3 hour) ===
java:
Converting 2010-11-06 09:00 from US/Eastern to US/Pacific.
Result: 2010-11-06 06:00. Change (-3 hour).
joda:
Converting 2010-11-06 09:00 from US/Eastern to US/Pacific.
Result: 2010-11-06 06:00. Change (-3 hour).
=======================================
=== November 12th, Expected Result (-3 hour) ===
java:
Converting 2010-11-12 09:00 from US/Eastern to US/Pacific.
Result: 2010-11-12 06:00. Change (-3 hour).
joda:
Converting 2010-11-12 09:00 from US/Eastern to US/Pacific.
Result: 2010-11-12 06:00. Change (-3 hour).
=======================================
=== March 12th, Expected Result (-3 hour) ===
java:
Converting 2010-03-12 09:00 from US/Eastern to US/Pacific.
Result: 2010-03-12 06:00. Change (-3 hour).
joda:
Converting 2010-03-12 09:00 from US/Eastern to US/Pacific.
Result: 2010-03-12 06:00. Change (-3 hour).
=======================================
=== March 14th, Expected Result (-3 hour) ===
java:
Converting 2010-03-14 09:00 from US/Eastern to US/Pacific.
Result: 2010-03-14 06:00. Change (-3 hour).
joda:
Converting 2010-03-14 09:00 from US/Eastern to US/Pacific.
Result: 2010-03-14 06:00. Change (-3 hour).
=======================================
这是完整的测试用例:
package com.test.time;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.TimeZone;
import org.joda.time.DateTimeZone;
import org.junit.Before;
import org.junit.Test;
public class TimeTest {
Calendar nov6;
Calendar nov1;
Calendar nov12;
Calendar mar12;
Calendar mar14;
@Before
public void doBefore() {
// November 1st 2010, 9:00pm (DST is active)
nov1 = Calendar.getInstance();
nov1.setTimeZone(TimeZone.getTimeZone("US/Arizona"));
nov1.set(Calendar.HOUR_OF_DAY, 21);
nov1.set(Calendar.MINUTE, 0);
nov1.set(Calendar.SECOND, 0);
nov1.set(Calendar.YEAR, 2010);
nov1.set(Calendar.MONTH, 10); // November
nov1.set(Calendar.DATE, 1);
// November 6st 2010, 9:00pm (DST is still active until early AM
// november 7th)
nov6 = Calendar.getInstance();
nov6.setTimeZone(TimeZone.getTimeZone("US/Arizona"));
nov6.set(Calendar.HOUR_OF_DAY, 21);
nov6.set(Calendar.MINUTE, 0);
nov6.set(Calendar.SECOND, 0);
nov6.set(Calendar.YEAR, 2010);
nov6.set(Calendar.MONTH, 10); // November
nov6.set(Calendar.DATE, 6);
// November 12th 2010, 9:00pm (DST has ended)
nov12 = Calendar.getInstance();
nov12.setTimeZone(TimeZone.getTimeZone("US/Arizona"));
nov12.set(Calendar.HOUR_OF_DAY, 21);
nov12.set(Calendar.MINUTE, 0);
nov12.set(Calendar.SECOND, 0);
nov12.set(Calendar.YEAR, 2010);
nov12.set(Calendar.MONTH, 10); // November
nov12.set(Calendar.DATE, 12);
// March 12th 2011, 9:00pm (DST has ended, will begin early a.m. march
// 13th)
mar12 = Calendar.getInstance();
mar12.setTimeZone(TimeZone.getTimeZone("US/Arizona"));
mar12.set(Calendar.HOUR_OF_DAY, 21);
mar12.set(Calendar.MINUTE, 0);
mar12.set(Calendar.SECOND, 0);
mar12.set(Calendar.YEAR, 2010);
mar12.set(Calendar.MONTH, 2); // March
mar12.set(Calendar.DATE, 12);
// March 14th 2011, 9:00pm (DST has started)
mar14 = Calendar.getInstance();
mar14.setTimeZone(TimeZone.getTimeZone("US/Arizona"));
mar14.set(Calendar.HOUR_OF_DAY, 21);
mar14.set(Calendar.MINUTE, 0);
mar14.set(Calendar.SECOND, 0);
mar14.set(Calendar.YEAR, 2010);
mar14.set(Calendar.MONTH, 2); // March
mar14.set(Calendar.DATE, 14);
}
@Test
public void testArizonaToPacific() {
System.out.println("=== November 1st, Expected Result (0 hour) ===");
timeTestJava(nov1.getTime(), "US/Arizona", "US/Pacific");
timeTestJoda(nov1.getTime(), "US/Arizona", "US/Pacific");
System.out.println("=======================================\n");
System.out.println("=== November 6th, Expected Result (0 hour) ===");
timeTestJava(nov6.getTime(), "US/Arizona", "US/Pacific");
timeTestJoda(nov6.getTime(), "US/Arizona", "US/Pacific");
System.out.println("=======================================\n");
System.out.println("=== November 12th, Expected Result (-1 hour) ===");
timeTestJava(nov12.getTime(), "US/Arizona", "US/Pacific");
timeTestJoda(nov12.getTime(), "US/Arizona", "US/Pacific");
System.out.println("=======================================\n");
System.out.println("=== March 12th, Expected Result (-1 hour) ===");
timeTestJava(mar12.getTime(), "US/Arizona", "US/Pacific");
timeTestJoda(mar12.getTime(), "US/Arizona", "US/Pacific");
System.out.println("=======================================\n");
System.out.println("=== March 14th, Expected Result (0 hour) ===");
timeTestJava(mar14.getTime(), "US/Arizona", "US/Pacific");
timeTestJoda(mar14.getTime(), "US/Arizona", "US/Pacific");
System.out.println("=======================================\n");
}
@Test
public void testEasternToPacific() {
System.out.println("=== November 1st, Expected Result (-3 hour) ===");
timeTestJava(nov1.getTime(), "US/Eastern", "US/Pacific");
timeTestJoda(nov1.getTime(), "US/Eastern", "US/Pacific");
System.out.println("=======================================\n");
System.out.println("=== November 6th, Expected Result (-3 hour) ===");
timeTestJava(nov6.getTime(), "US/Eastern", "US/Pacific");
timeTestJoda(nov6.getTime(), "US/Eastern", "US/Pacific");
System.out.println("=======================================\n");
System.out.println("=== November 12th, Expected Result (-3 hour) ===");
timeTestJava(nov12.getTime(), "US/Eastern", "US/Pacific");
timeTestJoda(nov12.getTime(), "US/Eastern", "US/Pacific");
System.out.println("=======================================\n");
System.out.println("=== March 12th, Expected Result (-3 hour) ===");
timeTestJava(mar12.getTime(), "US/Eastern", "US/Pacific");
timeTestJoda(mar12.getTime(), "US/Eastern", "US/Pacific");
System.out.println("=======================================\n");
System.out.println("=== March 14th, Expected Result (-3 hour) ===");
timeTestJava(mar14.getTime(), "US/Eastern", "US/Pacific");
timeTestJoda(mar14.getTime(), "US/Eastern", "US/Pacific");
System.out.println("=======================================\n");
}
// print some output from the test
private void print(Date startTime, String text, String from, String to,
Date output) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm");
System.out.println(text + ":");
System.out.println("Converting " + sdf.format(startTime) + " from "
+ from + " to " + to + ".");
long difference = output.getTime() - startTime.getTime();
System.out.println("Result: " + sdf.format(output) + ". Change ("
+ difference / 1000 / 60 / 60 + " hour).\n");
}
// wrapper around joda test
private void timeTestJoda(Date startTime, String from, String to) {
Date output = convertJodaOld(startTime, TimeZone.getTimeZone(from),
TimeZone.getTimeZone(to));
print(startTime, "joda", from, to, output);
}
// wrapper around java test
private void timeTestJava(Date startTime, String from, String to) {
Date output = convertJava(startTime, TimeZone.getTimeZone(from),
TimeZone.getTimeZone(to));
print(startTime, "java", from, to, output);
}
// Joda implementation, works before and after DST change, but not during
// the period from 2am-7am UTC on the day of the change
public Date convertJodaOld(Date dt, TimeZone from, TimeZone to) {
DateTimeZone tzFrom = DateTimeZone.forTimeZone(from);
DateTimeZone tzTo = DateTimeZone.forTimeZone(to);
Date utc = new Date(tzFrom.convertLocalToUTC(dt.getTime(), false));
Date convertedTime = new Date(tzTo.convertUTCToLocal(utc.getTime()));
return convertedTime;
}
// Java implementation. Works.
public Date convertJava(Date dt, TimeZone from, TimeZone to) {
long fromOffset = from.getOffset(dt.getTime());
long toOffset = to.getOffset(dt.getTime());
long convertedTime = dt.getTime() - (fromOffset - toOffset);
return new Date(convertedTime);
}
}
谢谢!
最佳答案
不要使用“美国/亚利桑那”,它已经过时了。
使用“美国/凤凰城”
'US/Pacific' 也是如此,请改用 'America/Los_Angeles'。
关于java - 非 DST 时区的 Joda 时间转换不正确,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/5148050/
在我的 Rails (3.0) 应用程序中,我使用助手 time_zone_select() 来使用时区。它生成时区名称,如“(GMT+01:00) Paris”... 但这些名称与 MySQL 中的
我正在解析格式为的日期: SimpleDateFormat formatter = new SimpleDateFormat("EE MMM dd HH:mm:ss Z yyyy"); 当我这样做的时
我在 Android 上使用 ACTION_TIMEZONE_CHANGED Intent 过滤器来响应时区更改。 我注意到 Jodas 当前时区此时没有更新,使用:DateTimeZone.getD
我有一个旧版 Windows 应用程序,它从数据库读取数据。其中一列是“TimeZoneInfoId”。在传统世界中,它是由另一个 Windows 应用程序编写的,因此它存储 Windows 字符串:
我是数据库开发新手,目前从事 MySQL 工作。我有一列包含美国的所有时区。我希望能够获取每行中每个时区的当前时间(只有时间,没有日期)。 时区数据如下:+05:00、-03:00 等等 这就是我尝试
我正在尝试了解 session 时区在 PostgreSQL 中的工作原理。 当我将 session 时区设置为“01:00”时,返回日期为“-01:00”。符号总是颠倒的,我不理解这种行为。 这怎么
我写入我的 mongoDB 数据库,例如开始日期,开始日期始终是一周中的星期一(我使用并且我在欧洲中部时区)。 "startDate" : ISODate("2014-12-28T23:00:00Z"
是否有详尽的 MySQL 时区列表? 似乎 MySQL 设置中 time_zone 的有效值取决于主机操作系统,但我一直无法找到可能值的列表。 我需要时间显示卡尔加里本地时间。 最佳答案 默认情况下,
我已经在 config/app.php 中配置了时区至 Europe/Lisbon . 如果我做 return date_default_timezone_get(); , 返回 Europe/Lis
我在整个脚本中广泛使用 unix 时间,通常我将时区设置如下: date_default_timezone_set('Europe/London'); 这一直工作正常,直到上周末时钟回退一个小时,我怀
我有一个字符串,2013-10-07T23:59:51.205-07:00,想将其转换为 Java 日期对象。我收到解析错误。 date = new SimpleDateFormat("yyyy-MM
如何更改日志文件名中的 log4j 时区? 我的 log4j.xml 文件:
在JAVA中,如何确定所有日期都作为GMT日期返回? 例如,即使我尝试使用GMT语言环境强制使用DateFormat,它也会应用某种逻辑来检索BST日期。 public static void mai
好吧,这是我遇到过的最奇怪的错误之一! 首先:我不是 Python 程序员,该脚本是由 friend 编写的(我认为他的大部分内容来自示例)。 该脚本的用途:将日历信息(CET 时间)从 XML 文件
我们有一个网站,目前在某个时间(由用户选择)运行拍卖,这一切都工作正常,因为当服务器到达该时间时,拍卖就会开始。然后我们必须添加时区,具体取决于用户居住的地方。然后,根据所选的下拉菜单,这将增加或减少
我陷入了这个逻辑。我正在开发一个消息调度项目,我的客户来自不同的国家。让我们考虑一下亚洲(不遵守夏令时)和美国/纽约(遵守夏令时)。 现在,我正在编写以下查询来获取距当前时间 10 分钟间隔内的时间表
我尝试返回特定时区的值,但我遇到了一些奇怪的响应行为: SELECT created_at AT TIME ZONE 'US/Pacific' - created_at, NOW() A
我正在尝试将不带时区值(例如“31.05.2015”)的字符串转换为 NSDate。 我的 DateFormatter 有什么问题?它返回日期 2015-05-31 22:00:00 +0000当我尝
我已经成功地将我的本地 tzinfo 导入到 mysql 中,我几乎已经了解了关于如何存储和使用这些数据的所有细节,除了一个字段。有一个名为 Transition_type_id 的数字字段(在表 t
为什么以下行返回的 TimeZone 显示不正确的时间: TimeZone.getTimeZone("America/Ottawa") 现在显示晚上 10:26 [亚特兰大时间现在是 6:26,Ott
我是一名优秀的程序员,十分优秀!