Seperate yyyymm to mm-yyyy
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I uploaded a table with one of the columns showing yyyymm,
How do I get tha column in the mm-yyyy format
0 commentaires
Réponses (1)
Star Strider
le 20 Jan 2020
Try this:
ym = [201910
201911
201912
202001]; % Numeric (?)
yms = compose('%6d',ym)
my = datetime(yms, 'InputFormat','yyyymm', 'Format','mm-yyyy')
producing:
my =
4×1 datetime array
10-2019
11-2019
12-2019
01-2020
6 commentaires
Stephen23
le 21 Jan 2020
Modifié(e) : Stephen23
le 21 Jan 2020
Note that for datetime objects lowercase mm represents minutes and uppercase MM represents months:
It is very unlikely that the data really encoded a timestamp of "yearminute" which should then be displayed as "minute-year". Because the datetime format capitalization is not very intuitiive, it is worth reading/checking the datetime documentation every time, to easily avoid these kind of bugs.
Voir également
Catégories
En savoir plus sur Data Distribution Plots 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!