How can I change timestamp format?

Question

Aakash Soni 2023-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1900445-how-can-i-change-timestamp-format

评论： Aakash Soni 2023-1-25

采纳的回答： Stephen23

在 MATLAB Online 中打开

Hello Matlab Community,

I have a dataset with timestamp which require some modification.

I would like to change the format of fractional seconds. For example, if a timestamp is 14:41:57:1, it should be changed to 14:41:57.001.

I tried following code but not getting success. I am getting 14:41:57.100 instead of 14:41:57.001.

>> a
a =
  2×1 cell array
    {'09.02.2022 14:41:56:999'}
    {'09.02.2022 14:41:57:1'  }
>> t = datetime(a,'InputFormat','dd.MM.yyyy HH:mm:ss:SSS')
t = 
  2×1 datetime array
   09-Feb-2022 14:41:56
   09-Feb-2022 14:41:57
>> t.Format = 'dd.MM.yyyy HH:mm:ss.SSS'
t = 
  2×1 datetime array
   09.02.2022 14:41:56.999
   09.02.2022 14:41:57.100
>> 

How can I change timestamp format in this case?

Thank you,

Aakash.

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2023-1-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1900445-how-can-i-change-timestamp-format#answer_1156035

编辑：Stephen23 2023-1-25

在 MATLAB Online 中打开

The best solution is to fix the source. Otherwise:

C = {'09.02.2022 14:41:56:999';'09.02.2022 14:41:57:1'}
C = 2×1 cell array
    {'09.02.2022 14:41:56:999'}
    {'09.02.2022 14:41:57:1'  }
D = regexprep(C,{':(\d\d)$',':(\d)$'},{':0$1',':00$1'});
T = datetime(D,'InputFormat','dd.MM.yyyy HH:mm:ss:SSS');
T.Format = 'dd.MM.yyyy HH:mm:ss.SSS'
T = 2×1 datetime array
   09.02.2022 14:41:56.999
   09.02.2022 14:41:57.001