Extracting the year from a timestamp in a column
2 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Stephen23
on 12 Jun 2018
Edited: Stephen23
on 12 Jun 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 Comments
Peter Perkins
on 5 Jul 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
More Answers (0)
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!