How can I convert datetime into double?
354 ビュー (過去 30 日間)
古いコメントを表示
I have a data which is 60 x 4320 datetime, each cell is 2019/01/01 00:00:00 and want to convert this into 60 x 4320 double.
I tried to use datevec(data) but it resulted 259200 x 6 double, one row one character, like
2019 01 01 00 00 00
2019 01 01 00 10 00
2019 01 01 00 20 00
3 件のコメント
Steven Lord
2021 年 11 月 17 日
You cannot have a double array where some of the elements are datetime values, that is true. But if you have date- and/or time-stamped data, I suggest using a timetable instead.
T = datetime('today');
randomDays = T + days(randi([-7 7], 10, 1));
x = (1:10).';
myTimedData = timetable(randomDays, x)
回答 (2 件)
galaxy
2019 年 12 月 12 日
Example:
>> t = datetime('now')
t =
datetime
2019/12/12 09:43:30
>> DateNumber = datenum(t)
DateNumber =
7.3777e+05
After that, if you want to convert back:
>> datetime(DateNumber,'ConvertFrom','datenum')
ans =
datetime
2019/12/12 09:43:30
hope it helps
0 件のコメント
Eric Sofen
2019 年 12 月 13 日
What do you want the doubles to represent?
Datenum returns a double represents days since 0 CE.
The posixtime function would give you a double representing seconds since the Unix epoch (00:00:00 1-Jan-1970 UTC).
The trouble with using double to represent dates and times is that there isn't one definition (there are also precision-related issues over long spans of time).
I'm curious if you'd be willing to share what you want to do with the doubles, and why you can't do it using datetime?
0 件のコメント
参考
カテゴリ
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!