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

5 views (last 30 days)
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!

Answers (1)

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

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!