Convert datetime into seperate columns

4 views (last 30 days)
I have a CSV table that I load in Matlab and looks as follows (see below). I would like to separate the datetime column into separate values in the form of a double array, with 1 column for 'year', 1 column for 'month', and 1 column for 'day', something like:
2020 | 07 | 20
2020 | 07 | 20
The hour is not important. How can I do this? I attach the CSV file which can be loaded as:
seawatertemp_westhinder = readtable('seawatertemp_westhinder.csv');

Accepted Answer

Brittany Scheid
Brittany Scheid on 25 Jul 2020
Edited: Brittany Scheid on 25 Jul 2020
In one line to get a double array:
[y,m,d] = ymd(seawatertemp_westhinder.times);
[y,m,d]
% Add to table
seawatertemp_westhinder.year= y
seawatertemp_westhinder.month = m
seawatertemp_westhinder.day= d

More Answers (0)

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!