convert dates to specific format
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
how can I change the format of the dates in the column shown in the image to the format uuuuMMddHHmm?
Risposte (2)
Stephen23
il 19 Lug 2022
Modificato: Stephen23
il 19 Lug 2022
My guess is that you have unfortunately stored each date as one numeric value, whose digits just happen to coincide with the date units' digits. This is rather a misuse of numerics, and is best fixed by importing that data correctly, rather than trying to "fix" it later. But you can convert to a proper DATETIME object if required:
N = 200701022359 % ugh
D = datetime(string(N),'Format','uuuuMMddHHmm')
Checking:
D.Year
D.Day
D.Minute
Note that you should avoid deprecated functions DATENUM, DATESTR, and DATEVEC.
0 Commenti
KSSV
il 19 Lug 2022
t0 = datenum(today) % probably you have datenums
t1 = datetime(datestr(t0)) % convert them to datetime
t1.Format % check the format
t1.Format = 'uuuuMMddHHmm' % change the format
3 Commenti
Stephen23
il 19 Lug 2022
"Any advice how to fix it?"
- understand how your date is currently stored.
- use that knowledge to select a suitable tool to convert it to DATETIME.
Vedere anche
Categorie
Scopri di più su Time Series Objects in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!