Effacer les filtres
Effacer les filtres

Date time conversion fail

2 vues (au cours des 30 derniers jours)
Karel Starý
Karel Starý le 29 Août 2022
Hello all,
I would like to conver a time to num format so i can do some basic math on it and then I wold like to format t back to day time format.
TimeFormat = 'yyyymmddHHMMSS';
st_file=cell(1,1);%Memory prealocation
t = w_files{2,1}(1,"time") %I am pulling a time from my data: 2022-08-08 10:18:12.000
t =
2022-08-08 10:18:12.000
t = table2array(t)%Converting it to cell because datestr does not work as it is right now
t =
2022-08-08 10:18:12.000
t = datestr(t,TimeFormat);%Making it a str
t =
t = datetime(t,"InputFormat",TimeFormat)%Changing it back to date time format
t =
08-Oct-2020 08:22:00
Is this how is the sotware intended to work? Where am I making a mistake and how can I avoid it in the future. Thanks!

Réponse acceptée

Karim le 29 Août 2022
From the looks of it, you need to change the months (M) and minutes (m) symbols in your time format to convert the string into expected datetime. See below:
TimeFormat = 'yyyyMMddHHmmSS';
t = "20220808101812"
t = "20220808101812"
t = datetime(t,"InputFormat",TimeFormat)
t = datetime
08-Aug-2022 10:18:00
  2 commentaires
Karel Starý
Karel Starý le 29 Août 2022
Modifié(e) : Karel Starý le 29 Août 2022
This works. After s gooli found out that date format is different for "datestr" function and "datetime" func. Wat a beatifull way to write a software, right :D
Thans anyway!
Walter Roberson
Walter Roberson le 29 Août 2022
datetime() was written using ISO standard codes for date and time. datestr() is older than the ISO standard.

Connectez-vous pour commenter.

Plus de réponses (1)

Steven Lord
Steven Lord le 29 Août 2022
I would like to conver a time to num format so i can do some basic math on it
What math do you want to do to the time data? There may be a way to avoid converting from time to number and back. For example:
T = datetime('today')
T = datetime
nextMonth = T + calmonths(1)
nextMonth = datetime
startOfThisMonth = dateshift(T, 'start', 'month')
startOfThisMonth = datetime


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





Community Treasure Hunt

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

Start Hunting!

Translated by