how to floor time for each hour?

tv = {'12-Dec-2021 09:09:04'
     '12-Dec-2021 09:24:04'
     '12-Dec-2021 09:39:04'
     '12-Dec-2021 09:54:04'};
dtv = datetime(tv, 'Format','dd-MMM-yyyy HH')                   % Display Only The Hour
dtv = 4×1 datetime array
   12-Dec-2021 09
   12-Dec-2021 09
   12-Dec-2021 09
   12-Dec-2021 09
dtv = datetime(tv, 'Format','dd-MMM-yyyy HH:00:00')             % Display Hour, Set Rest To Zeros
dtv = 4×1 datetime array
   12-Dec-2021 09:00:00
   12-Dec-2021 09:00:00
   12-Dec-2021 09:00:00
   12-Dec-2021 09:00:00

The 'Format' name-value pair controls the display, so set it however you want it.

.

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

Star Strider 2022-3-16

编辑：Star Strider 2022-3-16

As always, my pleasure!

EDIT — (16 Mar 2022 at 12:40)

To summarise the data for each hour, use the table2timetable function and then the retime function.

.

Lilya 2022-3-16

Noted

请先登录，再进行评论。

Answer 2

Steven Lord 2022-3-15

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1672074-how-to-floor-time-for-each-hour#answer_918169

在 MATLAB Online 中打开

If you want to actually modify the data rather than just changing how the data is displayed you can use dateshift.

tv = {'12-Dec-2021 09:00:00', 
     '12-Dec-2021 09:09:04'
     '12-Dec-2021 09:24:04'
     '12-Dec-2021 09:39:04'
     '12-Dec-2021 09:54:04'};
dtv = datetime(tv)
dtv = 5×1 datetime array
   12-Dec-2021 09:00:00
   12-Dec-2021 09:09:04
   12-Dec-2021 09:24:04
   12-Dec-2021 09:39:04
   12-Dec-2021 09:54:04
dtv2 = dateshift(dtv, 'start', 'hour')
dtv2 = 5×1 datetime array
   12-Dec-2021 09:00:00
   12-Dec-2021 09:00:00
   12-Dec-2021 09:00:00
   12-Dec-2021 09:00:00
   12-Dec-2021 09:00:00

To check that the data has actually been changed:

dtv2 == dtv(1)
ans = 5×1 logical array
   1
   1
   1
   1
   1

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

Steven Lord 2022-3-16

Based on your answer to KSSV's comment "to have the data at each hour instead of having different time steps for each hour" I suspect that storing your data in a timetable array and using retime to retime it to an hourly basis might be a solution to your larger problem.

Lilya 2022-3-17

yes.. I did that and it works perfectly!

thank you very very much.

请先登录，再进行评论。

Answer 3

Arif Hoq 2022-3-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1672074-how-to-floor-time-for-each-hour#answer_918024

在 MATLAB Online 中打开

A={'12-Dec-2021 09:09:04'
    '12-Dec-2021 09:24:04'
    '12-Dec-2021 09:39:04'
    '12-Dec-2021 09:54:04'};
B=datetime(A,'Format','hh') % if only hour
B1=datetime(A,'Format','hh:mm:ss') % if hour,min,sec