How do I convert tall array duration time vector to HH:mm:ss for merging with tall array datetime vector ?

7 次查看（过去 30 天）

Douglas Leaffer 2022-1-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1633670-how-do-i-convert-tall-array-duration-time-vector-to-hh-mm-ss-for-merging-with-tall-array-datetime

评论： Douglas Leaffer 2022-4-20

Need some help with this. I have a tall array date vector 'yyyy-MM-dd' of datetime format, and a tall array time vector 'HH:mm:ss.SSS' of duration format. How do I convert the duration vector to only HH:mm:ss (omitting the decimals) and then combine that with the date vector to get: 'yyyy-MM-dd HH:mm:ss' ?

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

请先登录，再进行评论。

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

采纳的回答

Chris 2022-1-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1633670-how-do-i-convert-tall-array-duration-time-vector-to-hh-mm-ss-for-merging-with-tall-array-datetime#answer_879295

在 MATLAB Online 中打开

dates = tall(repmat(datetime(date),3,1))
dates =

  3×1 tall datetime array

   21-Jan-2022
   21-Jan-2022
   21-Jan-2022
times = tall(repmat(duration(15,12,1,345,'Format','hh:mm:ss.SSS'),3,1))
times =

  3×1 tall duration array

   15:12:01.345
   15:12:01.345
   15:12:01.345
times.Format = 'hh:mm:ss';
datetime([string(dates) + " " + string(times)])
ans =

  3×1 tall datetime array

   21-Jan-2022 15:12:01
   21-Jan-2022 15:12:01
   21-Jan-2022 15:12:01

9 个评论
显示 7更早的评论隐藏 7更早的评论

Chris 2022-4-19

编辑：Chris 2022-4-19

在 MATLAB Online 中打开

Hello again, Douglas.

How about the following?

dates = datestr(theTable{:,1},'dd-mmm-yyyy');
durs = datestr(theTable{:,2},'HH:MM:SS');
merged = datetime(dates + " " + durs);

You could also shift the table around:

theTable.Var1 = merged;
theTable.Var2 = [];

Douglas Leaffer 2022-4-20

Chris, that works fine. Thank you for your suggestions.

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson 2022-1-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1633670-how-do-i-convert-tall-array-duration-time-vector-to-hh-mm-ss-for-merging-with-tall-array-datetime#answer_879285

在 MATLAB Online 中打开

perhaps

[h,m,s] = hms(DURATION_COLUMN);
DATETIME_COLUMN = TIME_COLUMN + duration(h,m,floor(s))

or perhaps

DATETIME_COLUMN = dateshift(TIME_COLUMN + DURATION_COLUMN, 'start', 'second')

if you do not have negative durations or negative datetimes, then adding first and then getting rid of the fractions of a second should give the same result.