MATLAB Answers

How do I convert this string to a date ?

5 ビュー (過去 30 日間)
Jules PASCO
Jules PASCO 2021 年 5 月 26 日
コメント済み: Jules PASCO 2021 年 6 月 2 日
Hi everybody !
I'm trying to turn this string to a date (from a txt file): 2021-05-11T14:11:00Z to 'yyyy-MM-dd HH:mm:ss'.
I tried with datetime(ref_time(h, 1),'InputFormat', 'yyyy-MM-dd e HH:mm:ss e','Format','yyyy-MM-dd HH:mm:ss') with an 'e' replacing the 'T' and 'Z' but id doesn't work...

回答 (2 件)

Asmit Singh
Asmit Singh 2021 年 5 月 26 日
Since you are trying to convert strings to date with literals like 'T' and 'Z', you may want to look at the "Date and Time from Text with Literal Characters" section in the documentation.
The below code converts the given string format to matlab datetime variable.
myDate = "2021-05-11T14:11:10Z"
datetime(myDate,'InputFormat','yyyy-MM-dd''T''HH:mm:ss''Z')
  8 件のコメント
Jules PASCO
Jules PASCO 2021 年 6 月 2 日
Ok! It works now!
To make the dates match the values, I imported my data files as arrays instead of vectors/matrices like before, but I have the impression that matlab differentiates arrays from matrices, which prevents me from doing the date conversion...
If I can't do it any other way I'd switch my array to matrix but the point of array is that it recognizes dates.

サインインしてコメントする。


Allen
Allen 2021 年 5 月 26 日
Try running a string replacement to remove "T" and "Z" from your string before reformatting to datetime.
str = "2021-05-11T14:11:00Z";
datetime(regexprep(str,["T","Z"],[" ",""]))
ans = datetime
11-May-2021 14:11:00
  1 件のコメント
Stephen
Stephen 2021 年 5 月 26 日
The "T" is specified in ISO 8601, it would be a very unfortunate if DATETIME could not handle it:
The "Z" refers to the Zulu time zone:
and as such it conveys important information which cannot be disregarded:
S = '2021-05-11T14:11:00Z';
T = datetime(S,'InputFormat','yyyy-MM-dd''T''HH:mm:ssZ', 'TimeZone','UTC')
T = datetime
11-May-2021 14:11:00
T.TimeZone = 'Asia/Shanghai'
T = datetime
11-May-2021 22:11:00

サインインしてコメントする。

製品

Community Treasure Hunt

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

Start Hunting!

Translated by