How to convert Data from 'yyyyMMddhhmm' format to datetime format

Question

Marie Gammelmark 2021-11-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1582344-how-to-convert-data-from-yyyymmddhhmm-format-to-datetime-format

评论： Marie Gammelmark 2021-11-9

Hello

I have been searching for a solution to converting my data from a number value with a 'yyyyMMddhhmm' format to a datetime format. Previously i attempted the following:

dtm = datetime(HS_Date,'InputFormat','yyyyMMddHHmm');

where HS_date is a matrix of 1x52561 double values, the data is from 202201010000 to 202301010000.

But i get an error message saying the following: "Error using Datetime (line 588) Numeric input data must be a matrix with three or six columns, or else three, six, or seven separate numeric arrays. You can also create datetimes from a single numeric array using the 'ConvertFrom' parameter."

The ConvertFrom parameter only offers the yyyMMdd format and is not an viable option.

I am unsure if i am defining anything wrongly, or if i need to format my data differently to make the function work.

note: my data is showcased in the program as 202201010000.000, but i cannot change or remove the decimals using the round or fix function.

Kind regards

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2021-11-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1582344-how-to-convert-data-from-yyyymmddhhmm-format-to-datetime-format#answer_827294

编辑：Stephen23 2021-11-9

在 MATLAB Online 中打开

"... HS_date is a matrix of 1x52561 double values, the data is from 202201010000 to 202301010000."

Abuse of decimal numbers to represent date/time values in entirely different bases that coincidentally happen to have the same digits... ugh, Ugh, UGH. The best solution would be to store/import that data correctly.

But that unnatural data can be converted to DATETIME with a little bit of effort:

N = [202201010000;202301010000]; % very badly designed data.
D = datetime(compose("%d",N),'InputFormat','yyyyMMddHHmm')
D = 2×1 datetime array
   01-Jan-2022
   01-Jan-2023

If you only need to date part then you could use the inbuilt ConvertFrom:

D = datetime(N/1e4,'ConvertFrom','yyyymmdd')
D = 2×1 datetime array
   01-Jan-2022
   01-Jan-2023

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Marie Gammelmark 2021-11-9

Thank you very much for the help!

请先登录，再进行评论。

Answer 2

Chunru 2021-11-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1582344-how-to-convert-data-from-yyyymmddhhmm-format-to-datetime-format#answer_827289

在 MATLAB Online 中打开

dstr = ["202201010000.000" "202301010000.000"]
dstr = 1×2 string array
    "202201010000.000"    "202301010000.000"
t = datetime(dstr,'InputFormat','yyyyMMddHHmm.SSS')
t = 1×2 datetime array
   01-Jan-2022   01-Jan-2023