Convert from Coordinated UTC to datetime?
51 ビュー (過去 30 日間)
古いコメントを表示
I have a list of times formatted in coordinated UTC time. For example, the first data entry point I have is
1.511092230713565e+05
where the first six digits are the year, month and day (so 11/09/2015) and the rest of the digits are the fraction of the day. How do I extract the the first six digits and then convert the rest of the digits so I can convert the time to a datenum array?
0 件のコメント
回答 (2 件)
Dave B
2021 年 11 月 5 日
編集済み: Dave B
2021 年 11 月 5 日
You can do this easily with datetime:
x=1.511092230713565e+05;
% The date part is the part before the decimal, so use floor
d = datetime(string(floor(x)),'InputFormat','yyMMdd')
% The time part is fractions of a day, remove the date part and call days
% to get a duration
t = days(x-floor(x))
% The result is the date part (which will be midnight) plus the fraction of
% a day
dt = d+t
% If you really must use datenum (though this is not recommended, datetime is so much better!)
datenum(dt)
0 件のコメント
Star Strider
2021 年 11 月 5 日
A different approach —
format long g
nr = 1.511092230713565e+05;
dt = datetime(num2str(fix(nr)),'InputFormat','yyMMdd') + timeofday(datetime(datevec(rem(nr,1))))
dn = datenum(dt)
.
1 件のコメント
Dave B
2021 年 11 月 5 日
I like the rem(nr,1) better than my x-floor(x), and I think fix is technically the accurate choice if there might be some BC dates?
Less sure about timeofday(datetime(datevec())) vs. days()
参考
カテゴリ
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!