我需要一个好的OLEDate java实现,而this one似乎不工作。有没有已知的好的开源实现(比如apache commons)?如果没有,我在哪里读到它,以便我写我自己的实现?
发布于 2013-06-22 01:01:09
尝试以下代码:
public static Date getDateFromCOMDate(float comtime) {
String floatstr = String.valueOf(comtime);
String [] ss = floatstr.split("\\.");
long nulltime = -2209183200000L;
long dayms = 86400000;
int days = Integer.valueOf(ss[0]);
float prop = comtime - days;
long cdayms = Math.round(dayms * prop);
long time = nulltime + days*dayms + cdayms;
Date d = new Date(time);
return d;
}发布于 2015-02-12 22:11:52
之前的实现是错误的,例如1.0和-1.25的错误日期。下面的实现符合MSDN中描述的OLE日期,例如:https://msdn.microsoft.com/en-us/library/system.datetime.tooadate(v=vs.110).aspx
下面的实现确实符合MSDN文档。它将Joda值转换为BigDecimal LocalDateTime。BigDecimal比float和double更好,因为它能够保存精确的值。
class COMDateToRegularDateConverter {
private static final LocalDateTime ZERO_COM_TIME = new LocalDateTime(1899, 12, 30, 0, 0);
private static final BigDecimal MILLIS_PER_DAY = new BigDecimal(86400000);
LocalDateTime toLocalDateTime(BigDecimal comTime) {
BigDecimal daysAfterZero = comTime.setScale(0, RoundingMode.DOWN);
BigDecimal fraction = comTime.subtract(daysAfterZero).abs(); //fraction always represents the time of that day
BigDecimal fractionMillisAfterZero = fraction.multiply(MILLIS_PER_DAY).setScale(0, RoundingMode.HALF_DOWN);
return ZERO_COM_TIME.plusDays(daysAfterZero.intValue()).plusMillis(fractionMillisAfterZero.intValue());
}
}https://stackoverflow.com/questions/2599102
复制相似问题