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

5 visualizzazioni (ultimi 30 giorni)
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!

Risposte (1)

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

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by