converting date and time string to datetime object

2 vues (au cours des 30 derniers jours)
Salma fathi
Salma fathi le 30 Mar 2022
Commenté : VBBV le 30 Mar 2022
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');

Réponse acceptée

VBBV
VBBV le 30 Mar 2022
Modifié(e) : VBBV le 30 Mar 2022
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 commentaires
Salma fathi
Salma fathi le 30 Mar 2022
thank you problem solved.
VBBV
VBBV le 30 Mar 2022
Please accept the answer if it solved. :) thanks

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Produits


Version

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by