How do I convert a date time format that's (dd-MMM-yyyy hh:mm:ss) to (dd-MMM-yyyy hh)?

Question

Shayma Al Ali 2021-1-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/721569-how-do-i-convert-a-date-time-format-that-s-dd-mmm-yyyy-hh-mm-ss-to-dd-mmm-yyyy-hh

回答： Steven Lord 2021-1-19

I'm having trouble converting a datetime column thats in the format (dd-MMM-yyyy hh:mm:ss) to (dd-MMM-yyyy hh), so basically just removing the minutes and seconds from the datetime.

The current code I have is down below but some of the dates don't convert into the format I would like.

d=gd_all.wc_datetime;
d.Format = 'dd-MMM-yyyy hh';
gd_date=cellstr(d);
gd_date=datetime(gd_date,'InputFormat','dd-MMM-yyyy hh');

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2021-1-19

We could only comment on data-dependent behavior with the sample data that seems to cause an issue.

Attach a .mat file that contains at least enough data that demonstrates what you think is a problem.

请先登录，再进行评论。

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

Answer 1

Steven Lord 2021-1-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/721569-how-do-i-convert-a-date-time-format-that-s-dd-mmm-yyyy-hh-mm-ss-to-dd-mmm-yyyy-hh#answer_601619

Do you want to change the displayed value or the stored value?

dt = datetime('now')
dt = datetime
   19-Jan-2021 22:44:04
dt_display = dt; % Make a copy so dt can be used as a reference later
dt_display.Format = 'dd-MMM-yyyy HH'
dt_display = datetime
   19-Jan-2021 22
dt_stored = dt;
dt_stored = dateshift(dt_stored, 'start', 'hour')
dt_stored = datetime
   19-Jan-2021 22:00:00
dt_display - dt_stored
ans = duration
   00:44:04
dt_display - dt % no difference
ans = duration
   00:00:00
dt - dt_stored % difference
ans = duration
   00:44:04

You can see that dt_display still contains the minutes and seconds of the current date and time while dt_stored has been set to the start of the hour.