Convert data table to datetime
149 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Raphael Willi
il 5 Mag 2021
Commentato: Raphael Willi
il 6 Mag 2021
I have data shown in the image.
I want to convert the second row into a datetime vector, but InputFormat doesn't work.
It's a number, e.g. 201401010000 meaning jan 1st 2014 00:00.
I tried datetime( BLA,'InputFormat','yyyyMMddHHmm')
0 Commenti
Risposta accettata
Adam Danz
il 5 Mag 2021
Modificato: Adam Danz
il 6 Mag 2021
> It's a number, e.g. 201401010000 meaning jan 1st 2014 00:00.
x = 201401010000;
dt = datetime(string(x),'InputFormat','yyyyMMddHHmm')
The 'format' property specifies the output format.
x can be a column of values.
3 Commenti
Adam Danz
il 6 Mag 2021
> I want to convert the second row into a datetime vector
> I would like to e.g. convert it to a timetable
Those are two very different questions.
I've updated my answer. After converting the column to datetime use
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Type Conversion 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!