Seperate yyyymm to mm-yyyy

2 次查看（过去 30 天）

显示更早的评论

Megan Mirkhanian 2020-1-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/501173-seperate-yyyymm-to-mm-yyyy

编辑： Stephen23 2020-1-21

I uploaded a table with one of the columns showing yyyymm,

How do I get tha column in the mm-yyyy format

回答（1 个）

Star Strider 2020-1-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/501173-seperate-yyyymm-to-mm-yyyy#answer_411119

在 MATLAB Online 中打开

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 个评论
显示 4更早的评论隐藏 4更早的评论

Star Strider 2020-1-21

@Walter — Thank you!

Stephen23 2020-1-21

编辑：Stephen23 2020-1-21

Note that for datetime objects lowercase mm represents minutes and uppercase MM represents months:

https://www.mathworks.com/help/matlab/ref/datetime.html#buhzxmk-1-Format

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.

请先登录，再进行评论。

请先登录，再回答此问题。