How to insert datetime data into table ?

2018 1 25
1 个回答
更新时间：2018 1 25
12 次查看（30 天）

2 个投票

I have a 2976x1 datetime data that contains date and time from 01-Dec-2016 00:15:00 to 01-Jan-2017 00:00:00 with time different is 15 mins. How can I insert this data into A(:,2) of matrix A size 2976x4 table.
Thank you in advance

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

回答（1 个）

Walter Roberson
Walter Roberson 2018-1-25

5 个投票

A{:,2} = TheTimeData(:);

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Pradya Panyainkaew
Pradya Panyainkaew 2018-1-25
Thanks for your suggestion Walter Roberson. But it cannot work because TheTimeData matrix is a data type "datetime". The software doesn't allow we insert datetime variables into table array. It shows the error like this "Right hand side of an assignment into a table must be another table or a cell array."
Walter Roberson
Walter Roberson 2018-1-25
A.Var2 = TheTimeData(:);
where Var2 is the name of the second column.
Pradya Panyainkaew
Pradya Panyainkaew 2018-1-25
Excellent. Finally, it's work. thank you very much Walter Roberson.
Peter Perkins
Peter Perkins 2018-1-25
Pradya, "The software doesn't allow we insert datetime variables into table array." is only true for parenthesis subscripting. There are several ways to add a new variable to a table. Walter's second suggestion is the most obvious and efficient, but you caould also have created a table with one variable out of your datetime vector, and assigned that to the table with parenthesis subscripting, or even just concatenated it onto the right side.
Steven Lord
Steven Lord 2018-1-25
If the times are somehow "special" in your table, consider converting your table into a timetable with your datetime variable as the RowTimes. You can do this using the table2timetable function, specifically the last signature in the Description section on that page. For more information on what you can do with a timetable, see the documentation.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by