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

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');

[dpb]

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]

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.