converting date and time string to datetime object
显示 更早的评论
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');
采纳的回答
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
5 个评论
Salma fathi
2022-3-30
编辑：Salma fathi
2022-3-30
VBBV
2022-3-30
Ionotable(k,1) = datetime(string(x),'InputFormat','uuuu-MM-dd''T''HH:mmXXX','TimeZone','UTC');
use a different input format
VBBV
2022-3-30
Ionotable(k,1) = datetime(string(x),'InputFormat','uuuu-MM-dd''T''HH:mmXXX','TimeZone','UTC');
Itable(k,1) = datetime(string(Ionotable(k,1)),'InputFormat','yyMMddHHmmss') %
2 step conversion may be needed
Salma fathi
2022-3-30
VBBV
2022-3-30
Please accept the answer if it solved. :) thanks
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
