convert from datetimes to double

47 次查看（过去 30 天）
James Upton
James Upton 2019-7-16
评论： Steven Lord 2019-7-16
I have created a variable called P_D and I want to put into it a date time asociated with each row (its financial data)
P_D(i,1)=data.Dates(i);
P_D(i,2)=data.Close(i);
P_D(i,3)=Premium;
When I run the code it is saying:
The following error occurred converting from datetime to double:
Undefined function 'double' for input arguments of type 'datetime'. To convert from datetimes to numeric, first subtract off a
datetime origin, then convert to numeric using the SECONDS, MINUTES, HOURS, DAYS, or YEARS functions.
Error in test2 (line 38)
P_D(i,1)=data.Dates(i);
How do I convert to numeric? '09-Jul-2019 02:25:00'
  2 个评论
Walter Roberson
Walter Roberson 2019-7-16
What would you want the numeric value to be?
James Upton
James Upton 2019-7-16
anything which I can display on a chart as the date on the X axis and price on the Y axis. That is what I am trying to achieve.

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson
Walter Roberson 2019-7-16
datenum() the datetime object.
This is not preferred. Consider using a table object or better yet a timetable
  2 个评论
James Upton
James Upton 2019-7-16
I want to display on a chart the date on the X axis and price on the Y axis. That is what I am trying to achieve.
Steven Lord
Steven Lord 2019-7-16
I second Walter's suggestion of storing your data in a timetable. Once you've done that, you could call plot on the times stored in the timetable as the first input and the numeric data as the second input.
t = datetime('today')+days(0:5).';
r = (0:5).'.^2;
tt = timetable(t, r);
plot(tt.t, tt.r)
Yes, I know in this example I could just as easily have plotted the data using t and r directly. But I'm assuming you may be performing some manipulation or analysis on the data before visualizing it, and many functions can accept a timetable.

请先登录，再进行评论。

类别

在 Help Center 和 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