How to round milliseconds of datetime Format?

Question

Brett Mather 2020-6-10

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/546002-how-to-round-milliseconds-of-datetime-format

回答： Brett Mather 2020-6-29

Here's an example:

>> dt = datetime("098:17:17:34.475", 'InputFormat', 'DDD:HH:mm:ss.SSS', 'Format', 'DDD:HH:mm:ss.SSS')
dt = 
  datetime
   098:17:17:34.475
   
>> SecsSinceNewYear = seconds(dt - datetime(dt.Year, 1, 0, 0, 0, 0, 0))
SecsSinceNewYear =
               8529454.475
>> dt = datetime(0, 1, 0, 0, 0, SecsSinceNewYear, 'Format', 'DDD:HH:mm:ss.SSS')
dt = 
  datetime
   098:17:17:34.474
   
>> string(dt)
ans = 
    "098:17:17:34.474"    
   
>> dt.Format = 'DDD:HH:mm:ss.SSSSSSSSS'
dt = 
  datetime
   098:17:17:34.474999999

Notice that the input ends in 475 milliseconds, but when displayed there seems to be a precision error that ends up not rounding and displays 474 milliseconds. So when I attempt to convert the datetime back into it's original string form the millisecnds have changed from 475 to 474.

Is there anyway to avoid this error introduced by converting these formats?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Brett Mather 2020-6-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/546002-how-to-round-milliseconds-of-datetime-format#answer_458569

在 MATLAB Online 中打开

Following up after getting support from MathWorks:

This was identified as a bug that exists in at least R2017b (maybe others) but is supposedly fixed in 2018a and later (I haven't checked as I'm using 2017b).

To further clarify the bug:

>> dt = datetime(0, 1, 0, 0, 0, 8.529454475000000e+06, 'Format', 'DDD:HH:mm:ss.SSS')
dt = 
  datetime
   098:17:17:34.474

Notice that the double I input for 'seconds' in datetime ends in 475 milliseconds and the output from datetime formatted to show milliseconds shows 474.

To work around this in 2017b do the following to split the original double into 'seconds' and 'milliseconds' before input to datetime:

>> start = 8.529454475000000e+06;
>> s = floor(start);
>> ms = round((start - s)*1000);
>> dt = datetime(0, 1, 0, 0, 0, s, ms, 'Format', 'DDD:HH:mm:ss.SSS')
dt = 
  datetime
   098:17:17:34.475