Extracting the year from a timestamp in a column
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a set of 477 values in a column, each that are formatted 'yyyy-mm-dd HH:MM:SS' and am trying to extract only the year using a loop
for i=1:477
[t] = datevec(data{i,8},'yyyy-mm-dd HH:MM:SS');
't_years' = t.Year;
end
0 commentaires
Réponse acceptée
Stephen23
le 12 Juin 2018
Modifié(e) : Stephen23
le 12 Juin 2018
Your code confuses a date vector (which is a simple double matrix of size Nx6 or Nx3) with a datetime object (which has the property obj.Year). If you want to use that property then you will need to use a datetime object. If you want to use datvec, then you do not need a loop as it accepts a cell array of char vectors directly. So probably something like this will work (it depends on how the data is arranged in data):
mat = datevec(data(:,8),'yyyy-mm-dd HH:MM:SS');
year = mat(:,1);
2 commentaires
Peter Perkins
le 5 Juil 2018
And if you want to stick with datetimes (which you probably do),
d = datetime(data{i,8},'yyyy-MM-dd HH:mm:ss');
y = d.Year
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Loops and Conditional Statements dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!