converting date and time string to datetime object

1 次查看（过去 30 天）

Salma fathi 2022-3-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1684109-converting-date-and-time-string-to-datetime-object

评论： VBBV 2022-3-30

I am trying to read several text files each has 4 variables, the first coumn has the date and time values otgether in the following format

''2022-02-16T15:50:00.000Z'', and I would like to convert them in the following format "20220216155000".

I would like to convert theis into a datetmir object so i can use these vaues to compare to other dates and times from a different tables.

I am using the following lines for converion

 for x = 1:length(Ionotable.x_Time)   %x_Time is the column where the date and tie values are stored
    Ionotable(x,1) = datetime(string(x),'InputFormat','yyMMddHHmmss'); 
   end

but I am getting the follwoing error

   Error using datetime (line 651)
Unable to convert '1' to datetime using the format 'yyMMddHHmmss'.
Error in Ionosonde_Data (line 23)
    Ionotable(x,1) = datetime(string(x),'InputFormat','yyMMddHHmmss'); 

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

请先登录，再进行评论。

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

采纳的回答

VBBV 2022-3-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1684109-converting-date-and-time-string-to-datetime-object#answer_930384

编辑：VBBV 2022-3-30

在 MATLAB Online 中打开

k = 1; 
while k<=length(Ionotable.x_Time)
     x = (Ionotable.x_Time(k))   %x_Time is the column where the date and tie values are stored
    Ionotable(k,1) = datetime(string(x),'InputFormat','yyMMddHHmmss'); 
    k = k+1;
end