问题 如何计算两个Java java.sql.Timestamps之间的差异?


请包括nanos,否则它将是微不足道的:

long diff = Math.abs(t1.getTime () - t2.getTime ());

[编辑]我想要最准确的结果,所以没有双打;只有整数/长整数。此外,结果必须是积极的。伪代码:

Timestamp result = abs (t1 - t2);

例子:

t1 = (time=1001, nanos=1000000), t2 = (time=999, nanos=999000000)
 -> diff = (time=2, nanos=2000000)

是的,java.sql.Timestamp中的毫秒数在时间和纳米标准中重复,因此1001毫秒表示1秒(1000)和1毫秒 time 部分和 nanos 因为1毫秒= 1000000纳秒)。这比它看起来更加狡猾。

我建议不要在没有实际测试代码或准备好工作代码示例的情况下发布答案:)


6426
2018-02-24 15:50


起源

那么,如果没有人得到它,你有一个解决方案吗? - Michael Myers♦
根据时间戳源代码中的注释,millis部分实际上并未在nanos中重复。相反,只有秒被存储在java.lang.Date的超类中,而nanos提供了所有剩余的时间。 - Richard
@mmyers:我正在研究一个,但我希望有人有一个工作的例子来拯救我可怜的大脑......但是我应该猜到没有人有谷歌没有改变任何东西,但t1.getTime() - t2。的getTime() - Aaron Digulla
@Richard:是的。狡猾的是他们做对了 国内。如果您调用API,它会将millis混合到两个字段中;看我的单位测试看起来有多奇怪。 - Aaron Digulla
该死的!这个垃圾带我一个小时! = 8 *○ - Aaron Digulla


答案:


经过一个小时和各种单元测试,我想出了这个解决方案:

public static Timestamp diff (java.util.Date t1, java.util.Date t2)
{
    // Make sure the result is always > 0
    if (t1.compareTo (t2) < 0)
    {
        java.util.Date tmp = t1;
        t1 = t2;
        t2 = tmp;
    }

    // Timestamps mix milli and nanoseconds in the API, so we have to separate the two
    long diffSeconds = (t1.getTime () / 1000) - (t2.getTime () / 1000);
    // For normals dates, we have millisecond precision
    int nano1 = ((int) t1.getTime () % 1000) * 1000000;
    // If the parameter is a Timestamp, we have additional precision in nanoseconds
    if (t1 instanceof Timestamp)
        nano1 = ((Timestamp)t1).getNanos ();
    int nano2 = ((int) t2.getTime () % 1000) * 1000000;
    if (t2 instanceof Timestamp)
        nano2 = ((Timestamp)t2).getNanos ();

    int diffNanos = nano1 - nano2;
    if (diffNanos < 0)
    {
        // Borrow one second
        diffSeconds --;
        diffNanos += 1000000000;
    }

    // mix nanos and millis again
    Timestamp result = new Timestamp ((diffSeconds * 1000) + (diffNanos / 1000000));
    // setNanos() with a value of in the millisecond range doesn't affect the value of the time field
    // while milliseconds in the time field will modify nanos! Damn, this API is a *mess*
    result.setNanos (diffNanos);
    return result;
}

单元测试:

    Timestamp t1 = new Timestamp (0);
    Timestamp t3 = new Timestamp (999);
    Timestamp t4 = new Timestamp (5001);
    // Careful here; internally, Java has set nanos already!
    t4.setNanos (t4.getNanos () + 1);

    // Show what a mess this API is...
    // Yes, the milliseconds show up in *both* fields! Isn't that fun?
    assertEquals (999, t3.getTime ());
    assertEquals (999000000, t3.getNanos ());
    // This looks weird but t4 contains 5 seconds, 1 milli, 1 nano.
    // The lone milli is in both results ...
    assertEquals (5001, t4.getTime ());
    assertEquals (1000001, t4.getNanos ());

    diff = DBUtil.diff (t1, t4);
    assertEquals (5001, diff.getTime ());
    assertEquals (1000001, diff.getNanos ());

    diff = DBUtil.diff (t4, t3);
    assertEquals (4002, diff.getTime ());
    assertEquals (2000001, diff.getNanos ());

10
2018-02-24 16:38



经过多次尝试,我无法让我的代码的BigInteger版本比你的代码慢三倍。这值得一提。 - Michael Myers♦
谢谢:) BigInt代码的优点是它是单行(并且更容易理解)。这就是我给它+1的原因。 - Aaron Digulla


在什么单位?你上面的差异将给出毫秒,Timestamp.nanos()返回一个int,它将是毫秒(百万分之一?)毫秒。你的意思是,例如

(t1.getTime () + (.000001*t1.getNanos()) - (t2.getTime () + (.000001*t2.getNanos())

还是我错过了什么?另一个问题是你需要这种精确度吗? AFAIK JVM不保证在这个级别上是精确的,我不认为这是重要的,除非你确定你的数据源是那么精确。


3
2018-02-24 15:58



缺少两个))在最后。 - Michael Myers♦
请给我一个确切的结果。 - Aaron Digulla
谢谢你的努力;我发布了一个确切的解决方案,但男孩,API是一个 食堂 - Aaron Digulla
如果时间戳中有毫秒,则结果将是错误加上1s == 1,000,000,000ns(10 ^ 9)。 - Aaron Digulla


以mmyers代码为基础......

import java.math.BigInteger;
import java.sql.Timestamp;


public class Main
{
    // 1s == 1000ms == 1,000,000us == 1,000,000,000ns (1 billion ns)
    public final static BigInteger ONE_BILLION = new BigInteger ("1000000000");
    public static void main(String[] args) throws InterruptedException 
    {
        final Timestamp t1;
        final Timestamp t2;
        final BigInteger firstTime;
        final BigInteger secondTime;
        final BigInteger diffTime;

        t1 = new Timestamp(System.currentTimeMillis());
        Thread.sleep(20);
        t2 = new Timestamp(System.currentTimeMillis());

        System.out.println(t1);
        System.out.println(t2);
        firstTime  = BigInteger.valueOf(t1.getTime() / 1000 * 1000).multiply(ONE_BILLION ).add(BigInteger.valueOf(t1.getNanos()));
        secondTime = BigInteger.valueOf(t2.getTime() / 1000 * 1000).multiply(ONE_BILLION ).add(BigInteger.valueOf(t2.getNanos()));
        diffTime   = firstTime.subtract(secondTime);
        System.out.println(firstTime);
        System.out.println(secondTime);
        System.out.println(diffTime);
    }
}

1
2018-02-24 16:46



+1:可能不是最快的解决方案,但绝对是最简单的代码。但是,尝试使用我的单元测试来运行代码。我认为只要nanos%1000000!= 0就会搞乱毫秒。 - Aaron Digulla
性能提示:这需要大约三倍于我的解决方案,但大约是编码时间的1/6。 - Aaron Digulla


(删除旧代码以缩短答案)

编辑2: 新代码:

public class ArraySizeTest {
    public static void main(String[] args) throws InterruptedException {
        Timestamp t1 = new Timestamp(System.currentTimeMillis());
        t1.setNanos(t1.getNanos() + 60);
        Thread.sleep(20);
        Timestamp t2 = new Timestamp(System.currentTimeMillis());
        t2.setNanos(t2.getNanos() + 30);
        System.out.println(t1);
        System.out.println(t2);
        // The actual diff...
        long firstTime = (getTimeNoMillis(t1) * 1000000) + t1.getNanos();
        long secondTime = (getTimeNoMillis(t2) * 1000000) + t2.getNanos();
        long diff = Math.abs(firstTime - secondTime); // diff is in nanos
        System.out.println(diff);
        System.out.println(Math.abs(t1.getTime() - t2.getTime()));
    }
    private static long getTimeNoMillis(Timestamp t) {
        return t.getTime() - (t.getNanos()/1000000);
    }
}

输出:

2009-02-24 10:35:15.56500006
2009-02-24 10:35:15.59600003
30999970
31

编辑3: 如果您更喜欢返回时间戳的内容,请使用以下命令:

public static Timestamp diff(Timestamp t1, Timestamp t2) {
    long firstTime = (getTimeNoMillis(t1) * 1000000) + t1.getNanos();
    long secondTime = (getTimeNoMillis(t2) * 1000000) + t2.getNanos();
    long diff = Math.abs(firstTime - secondTime); // diff is in nanoseconds
    Timestamp ret = new Timestamp(diff / 1000000);
    ret.setNanos((int) (diff % 1000000000));
    return ret;
}
private static long getTimeNoMillis(Timestamp t) {
    return t.getTime() - (t.getNanos()/1000000);
}

此代码通过了您的单元测试。


0
2018-02-24 16:02



要转换为纳秒,您需要乘以1000000.问题是您是否会在某个时刻遇到长溢出。 - Richard
@Richard:是的,是的,似乎。 - Michael Myers♦
刚看到问题的编辑。哎哟。 :P - Michael Myers♦
@mmyers:这样的东西应该更简单......;)看看我的解决方案。 - Aaron Digulla
@SteveB:这会在一分钟内变得更好;) - Aaron Digulla