Add datetime vector which contains NaT to double

Question

Louise Wilson 2020-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/532408-add-datetime-vector-which-contains-nat-to-double

回答： Eric Sofen 2020-6-9

I have a 2546x7200 matrix and I would like to add a vector of datetimes to the first column. The first row of the matrix is frequency values, the first column would be datetimes, and the cells filled with decibel values. However, since the first row of the datetime vector is NaT, I get an error when I try to append it. How could I overcome this? Thanks!

I tried:

A=cat(2,t,output_plot);  
%where t is datetime vector and output_plot is the double matrix

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

请先登录，再进行评论。

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

Answer 1

Eric Sofen 2020-6-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/532408-add-datetime-vector-which-contains-nat-to-double#answer_448769

The NaT isn't the problem. You cannot concatenate datetime and double in a homogenous matrix:

>> x = [1 2 datetime('now')]
Error using datetime/horzcat (line 1387)
All inputs must be datetimes or date/time character vectors or date/time strings.

Either store the data in a table/timetable, which is intended to store variables of different types but the same height, or decide how you want to convert the datetime into something that can be represented as a double (i.e. if all you needed was hour-of-the-day, you could extract that), although that loses the datetime functionality.