Convert from Coordinated UTC to datetime?
47 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (2)
Dave B
il 5 Nov 2021
Modificato: Dave B
il 5 Nov 2021
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 Commenti
Star Strider
il 5 Nov 2021
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 Commento
Dave B
il 5 Nov 2021
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()
Vedere anche
Categorie
Scopri di più su Dates and Time in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!