MATLAB: How to separate date and time into 6 tables 01/01/2014 0:10:00? (year,month,day,hours,minutes and second)

separated

how to separate date and time into 6 tables 01/01/2014 0:10:00? (year,month,day,hours,minutes and second)

Best Answer

Use the datevec function.

Related Solutions

MATLAB: How to combine datetime and duration columns to form 1 new datetime column in table

%% Combining Into 1 table
t1 = datetime(2014,12,01,00,00,00);
t2 = datetime(2020,01,01,00,00,00);
t = t1:minutes(10):t2;
t = t.';
Tsum = datetime(t, 'InputFormat', 'dd-MM-yyyy hh:mm:ss');
Tsum = array2table(Tsum);
Tsum = table2timetable(Tsum);
for a = 1:9
    disp(['Sync start ', int2str(a)]);
    name = ['FileRef', int2str(a), '.csv'];
    Data1 = readtable(name);
    arr = [];
    
    for b = 1:length(Data1.Date)
        arr{b} = [char(Data1.Date(b)), ' ', char(Data1.Time(b))];
    end
    
    arr = arr.';
    arr = datetime(arr, 'InputFormat', 'dd-MM-yyyy HH:mm:ss');
    Data1.DateTime = arr;
    Data1 = Data1(:,[4 3]);
    name = ['Output', int2str(a)];
    Data1.Properties.VariableNames = {'DateTime' name};
    TT = table2timetable(Data1);
    
    Tsum = synchronize(Tsum, TT, 'first');
    disp([int2str(a), ' passed']);
end

MATLAB: How to combine data from seperate tables into one table with seperate columns

Assuming all tables have the same number of columns with matching Variable Names, you can vertically concatenate them like this.

T = [T1; T2; T3];

Best Answer

Related Solutions

MATLAB: How to combine datetime and duration columns to form 1 new datetime column in table

MATLAB: How to combine data from seperate tables into one table with seperate columns

Related Question