Extracting index of specified date from datetime array in dd:MM:yyyy:HH:mm:ss.SSS format

Question

Ben Whitby 2022-8-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1784460-extracting-index-of-specified-date-from-datetime-array-in-dd-mm-yyyy-hh-mm-ss-sss-format

回答： Chunru 2022-8-24

Hi All,

Getting frustrated as this should be seemingly simple to do. i have an array of datetime values in dd:MM:yyyy:HH:mm:ss.SSS format. I am trying to find the Index position of a specific time (03:04:2021:00:05:10.063)

TimeMatlab = [738249.003472956,738249.003530829,738249.003588699,738249.003646569,738249.003704439]
Time=datetime(TimeMatlab,'ConvertFrom','datenum','Format','dd:MM:yyyy:HH:mm:ss.SSS'); %Convert serial dates into dd:MM:yyyy:HH:mm:ss.SSS format

Time =

1×5 datetime array

03:04:2021:00:05:00.063 03:04:2021:00:05:05.063 03:04:2021:00:05:10.063 03:04:2021:00:05:15.063 03:04:2021:00:05:20.063

I then want to find the Index of 03:04:2021:00:05:10.063 in the datetime array Time (1,3).

The dates I need to serch for are in the dd:MM:yyyy:HH:mm:ss.SSS format hence I want to search for the index postion in Time rather than TimeMatlab if that makes sense.

Thanks

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

请先登录，再进行评论。

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

Answer 1

Chunru 2022-8-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1784460-extracting-index-of-specified-date-from-datetime-array-in-dd-mm-yyyy-hh-mm-ss-sss-format#answer_1031640

在 MATLAB Online 中打开

TimeMatlab = [738249.003472956,738249.003530829,738249.003588699,738249.003646569,738249.003704439];
Time=datetime(TimeMatlab,'ConvertFrom','datenum','Format','dd:MM:yyyy:HH:mm:ss.SSSSSSSS');  % SSSSSSS
Time = 1×5 datetime array
   03:04:2021:00:05:00.06339965   03:04:2021:00:05:05.06362402   03:04:2021:00:05:10.06359692   03:04:2021:00:05:15.06355957   03:04:2021:00:05:20.06353247
T0=datetime("03:04:2021:00:05:10.063",'InputFormat','dd:MM:yyyy:HH:mm:ss.SSS')
T0 = datetime
   03-Apr-2021 00:05:10
Time-T0
ans = 1×5 duration array
   -00:00:09   -00:00:04    00:00:00    00:00:05    00:00:10
[~, idx] = min(abs(seconds(Time-T0)))       % closest one to T0
idx = 3