db使用timestamp,纳秒信息丢失

2021-01-08  本文已影响0人  visionarywind

db使用timestamp,纳秒信息丢失

private Timestamp convertToUtc(Timestamp localTime) {
    Timestamp utcTimeStamp =  new Timestamp(localTime.getTime() + getLocalToUtcDelta());
    // 补偿丢失的纳秒精度
    utcTimeStamp.setNanos(localTime.getNanos());
    return utcTimeStamp;
}

private long getLocalToUtcDelta() {
    Calendar local = Calendar.getInstance();
    local.clear();
    local.set(1970, Calendar.JANUARY, 1, 0, 0, 0);
    return local.getTimeInMillis();
}
上一篇 下一篇

猜你喜欢

热点阅读