Problem converting a cell array of integers to datetime

Hi, I have an array if integers (100x1 cell), like 736696, 736697, ....
I try to use b = datetime(a, 'ConvertFrom', 'datenum'), but keep getting error "Input data must be a numeric or a cell array or char matrix containing date/time strings." Why?
Thanks

 采纳的回答

If your data is really stored in a cell:
a = {736696, 736697};
v = [a{:}]; % Converted to vector
b = datetime(a, 'ConvertFrom', 'datenum')
Many functions of Matlab expect numeric values in a numeric array and not as a cell. Cells are useful to store elements of different size or type.

4 个评论

Thanks. This works. What if a is a column in a table?
% Generate some sample data
theNextWeek = datetime('today') + days((0:6).')
N = datenum(theNextWeek)
% Use that sample data to build a table
T = table(N, 'VariableNames', {'Dates'})
% Extract the variable from the table and convert it
DT = datetime(T.Dates, 'ConvertFrom', 'datenum')
Compare theNextWeek and DT.
Thanks. When I ran the above sample code, there is no problem. But when I ran my small table, with it, I keep getting error: Input data must be a numeric or a cell array or char matrix containing date/time strings.
If I ran my code as below it works: out = datetime(myT{1}, 'ConvertFrom', 'datenum') but if I ran my code as: out = datetime(myT, 'ConvertFrom', 'datenum') It gives me the error message. I am quite puzzled.
OK. Found my problem: I have to use a cell2mat to convert my dates first! Thanks for all the help.

请先登录,再进行评论。

更多回答(0 个)

类别

帮助中心File Exchange 中查找有关 Dates and Time 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by