How do I convert a specific string to a date ?

1 次查看（过去 30 天）

显示更早的评论

Marpe 2022-7-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1770475-how-do-i-convert-a-specific-string-to-a-date

评论： Star Strider 2022-7-29

采纳的回答： Star Strider

Hi everyone,

I have acceleration measurements that were collected via a tag.

The time is recorded as '22-07-04T013:09:42Z' (it is exactly written like that in my data).

Do you know how I can convert this type of string into a date? And if it possible, select only the time which here would be '13:09:42' ?

I tried datetime and datenum functions but I guess the specific format makes it more complicated.

Thanks,

Marine

2 个评论
显示无隐藏无

Stephen23 2022-7-29

"The time is recorded as '22-07-04T013:09:42Z' (it is exactly written like that in my data)."

Please check your data: it is odd to use three digits for the hours. Otherwise, it looks like a normal ISO 8601 timestamp.

Marpe 2022-7-29

Yes I know it is odd but I can't do anything about it unfortunately…

请先登录，再进行评论。

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

采纳的回答

Star Strider 2022-7-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1770475-how-do-i-convert-a-specific-string-to-a-date#answer_1017540

在 MATLAB Online 中打开

Note the Comment by @Stephen23.

That aside, try this—

DT = datetime('22-07-04T013:09:42Z', 'InputFormat','dd-MM-yy''T''HHH:mm:ss''Z''', 'TimeZone','UTC')     % Convert To 'datetime'
DT = datetime
   22-Jul-2004 13:09:42
DT.Format = 'HH:mm:ss'                                                                                  % Select Only Time Time
DT = datetime
   13:09:42