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');

 채택된 답변

VBBV
VBBV 2022년 3월 30일
편집: VBBV 2022년 3월 30일
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

Thank you for replying to my question,
I am getting the follwoing error now,
Error using datetime (line 651)
Unable to convert '2022-01-01T00:00:00.000Z' to datetime using the format 'yyyyMMddHHmmss'.
Error in Ionosonde_Data (line 24)
Ionotable(ii,1) = datetime(string(x),'InputFormat','yyyyMMddHHmmss');
>>
Ionotable(k,1) = datetime(string(x),'InputFormat','uuuu-MM-dd''T''HH:mmXXX','TimeZone','UTC');
use a different input format
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
thank you problem solved.
Please accept the answer if it solved. :) thanks

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

도움말 센터File Exchange에서 Dates and Time에 대해 자세히 알아보기

제품

릴리스

R2021b

질문:

2022년 3월 30일

댓글:

2022년 3월 30일

Community Treasure Hunt

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

Start Hunting!

Translated by