Problems using "datetime" cont.
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Andy Wileman
il 17 Mar 2021
Commentato: Andy Wileman
il 17 Mar 2021
Hi,
Having solved problems with getting the current date from a structure into a table (thank you Adam). Using "datetime" still does not seem to be carrying out the conversion. Any thoughts?
Kind regards,
Andy
table
Dates
_________________________________
"12/24/2008 9:59:47 AM.786743640"
%Current file format{'12/24/2008 9:59:47 AM.786743640'}
%Fileformat to convert to = data-20130325T004512Z.mat
date=cell2mat(dateName);
data=cell2mat(timeDom);
N = date
T = table(string(N), 'VariableNames', {'Dates'})
dt = datetime('T.Dates','Format','yyyyMMdd''T''HHmmss''Z')
% TODO: Save files
save(data, '-append', '-struct', 'dt');
Error using datetime (line 640)
Unable to convert 'T.Dates' to datetime using the format 'yyyyMMdd'T'HHmmss'Z'.
Error in extractor (line 20)
dt = datetime('T.Dates','Format','yyyyMMdd''T''HHmmss''Z')
0 Commenti
Risposta accettata
Stephen23
il 17 Mar 2021
Modificato: Stephen23
il 17 Mar 2021
S = "12/24/2008 9:59:47 AM.786743640";
D = datetime(S, 'InputFormat','MM/dd/yyyy h:m:s a.SSSSSSSSS')
D.Format = 'yyyyMMdd''T''HHmmss''Z'''
You also need to refer to the table, not define a literal character vector:
datetime( T.Dates ,...) % correct way to refert to table T.
datetime('T.Dates',...) % defines a character vector, does not help you.
3 Commenti
Stephen23
il 17 Mar 2021
@Andy Wileman: note that I assumed that the trailing decimal fraction are fractional seconds. If they represent some other data, then you will need to make the required changes.
Più risposte (0)
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!