- 'Format' governs what the output looks like
- 'InputFormat' governs what the input looks like
Datetime won't recognise some cells
3 views (last 30 days)
Show older comments
I have a series of datetimes in the format 'HH:mm:ss.sss'. I am using the following code to convert from string into datetimes.
data.TimeofDay = datetime(data.TimeofDay,'Format','HH:mm:ss.sss')
In the attached .mat file, it contains the data file before and after the command above. For some reason, different values in the column are returned as NaT despite all rows seemingly being in the same format.
1 Comment
the cyclist
on 28 Jun 2022
Edited: the cyclist
on 9 Jul 2022
Relevant for both your code and some of the answers:
In your case, I believe MATLAB would have correctly inferred your input format, if had you left it unspecified:
datetime(data.TimeofDay)
Accepted Answer
Cris LaPierre
on 28 Jun 2022
For miliseconds, you want to use a capital 'S'.
load datetime-problem.mat
datetime(databackup.TimeofDay,'Format','HH:mm:ss.sss')
% corrected
datetime(databackup.TimeofDay,'Format','HH:mm:ss.SSS')
0 Comments
More Answers (2)
the cyclist
on 28 Jun 2022
Edited: the cyclist
on 28 Jun 2022
Two minor but important changes to your syntax:
datetime(data.TimeofDay,'InputFormat','HH:mm:ss.SSS')
Note that I used
- 'InputFormat' instead of 'Format'
- .SSS instead of .sss
0 Comments
Voss
on 28 Jun 2022
load datetime-problem.mat
databackup.TimeofDay
% original Format specification:
datetime(databackup.TimeofDay,'Format','HH:mm:ss.sss')
% corrected Format specification:
datetime(databackup.TimeofDay,'Format','hh:mm:ss.SSS')
0 Comments
See Also
Categories
Find more on Logical 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!