Datetime won't recognise some cells

2 次查看（过去 30 天）
Matt Smith
Matt Smith 2022-6-28
编辑： the cyclist 2022-7-9
Ran in:
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')
Unable to resolve the name 'data.TimeofDay'.
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 个评论
the cyclist
the cyclist 2022-6-28
编辑：the cyclist 2022-7-9
Relevant for both your code and some of the answers:
  • 'Format' governs what the output looks like
  • 'InputFormat' governs what the input looks like
In your case, I believe MATLAB would have correctly inferred your input format, if had you left it unspecified:
datetime(data.TimeofDay)

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Cris LaPierre
Cris LaPierre 2022-6-28
Ran in:
For miliseconds, you want to use a capital 'S'.
load datetime-problem.mat
datetime(databackup.TimeofDay,'Format','HH:mm:ss.sss')
ans = 14×1 datetime array
09:03:26.026 NaT NaT NaT NaT 09:10:47.047 NaT NaT NaT 09:16:15.015 NaT NaT NaT NaT
% corrected
datetime(databackup.TimeofDay,'Format','HH:mm:ss.SSS')
ans = 14×1 datetime array
09:03:32.026 09:05:04.939 09:06:32.609 09:07:58.886 09:09:23.436 09:10:48.047 09:12:12.351 09:13:42.538 09:15:07.079 09:16:41.015 09:36:12.951 09:37:52.603 09:39:16.163 09:40:41.993

更多回答（2 个）

the cyclist
the cyclist 2022-6-28
编辑：the cyclist 2022-6-28
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
Voss
Voss 2022-6-28
Ran in:
load datetime-problem.mat
databackup.TimeofDay
ans = 14×1 string array
"09:03:32.026" "09:05:04.939" "09:06:32.609" "09:07:58.886" "09:09:23.436" "09:10:48.047" "09:12:12.351" "09:13:42.538" "09:15:07.079" "09:16:41.015" "09:36:12.951" "09:37:52.603" "09:39:16.163" "09:40:41.993"
% original Format specification:
datetime(databackup.TimeofDay,'Format','HH:mm:ss.sss')
ans = 14×1 datetime array
09:03:26.026 NaT NaT NaT NaT 09:10:47.047 NaT NaT NaT 09:16:15.015 NaT NaT NaT NaT
% corrected Format specification:
datetime(databackup.TimeofDay,'Format','hh:mm:ss.SSS')
ans = 14×1 datetime array
09:03:32.026 09:05:04.939 09:06:32.609 09:07:58.886 09:09:23.436 09:10:48.047 09:12:12.351 09:13:42.538 09:15:07.079 09:16:41.015 09:36:12.951 09:37:52.603 09:39:16.163 09:40:41.993

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by