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

7 vues (au cours des 30 derniers jours)
Jade O'Brien-Smith
Jade O'Brien-Smith le 20 Mar 2020
Commenté : Sanduni le 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!

Réponses (1)

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

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by