How can I format the datetime when the format is not recognized?

8 Ansichten (letzte 30 Tage)
Jade O'Brien-Smith
Jade O'Brien-Smith am 20 Mär. 2020
Kommentiert: Sanduni am 8 Nov. 2022
Hello, I'm having some trouble setting my datetime format. The original timestamps I get looks like this "0200310T102613000" and I've tried to format it like this;
p1 = readtable('10.csv');
date1 = table2cell(p1(:,1));
dateT = datetime(date1,'InputFormat','YYYYmmdd''T''HHmmssSSS');
I've even tried removing the date secion (i.e. "102613000") and running is like this;
dateT = datetime(date1,'InputFormat','HHmmssSSS');
However I always get an error using the datetime function. Does anyone have any ideas for me?
Thanks!

Antworten (1)

Fangjun Jiang
Fangjun Jiang am 20 Mär. 2020
a="20200310T102613000";
>> datetime(a,'inputformat','yyyyMMdd''T''HHmmssSSS')
ans =
datetime
10-Mar-2020 10:26:13

Kategorien

Mehr zu Dates and Time finden Sie in Help Center und File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by