how to floor time for each hour?

4 views (last 30 days)
Lilya
Lilya on 15 Mar 2022
Commented: Lilya on 17 Mar 2022
Hi Experts,
I have this time format, and i want to have the time only for each hour. Could anyone please help with this?
'12-Dec-2021 09:09:04'
'12-Dec-2021 09:24:04'
'12-Dec-2021 09:39:04'
'12-Dec-2021 09:54:04'
Much appreciated
  2 Comments
Lilya
Lilya on 16 Mar 2022
to have the data at each hour instead of having different time steps for each hour

Sign in to comment.

Accepted Answer

Star Strider
Star Strider on 15 Mar 2022
Try this —
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 Comments

Sign in to comment.

More Answers (2)

Steven Lord
Steven Lord on 15 Mar 2022
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 Comments
Lilya
Lilya on 17 Mar 2022
yes.. I did that and it works perfectly!
thank you very very much.

Sign in to comment.


Arif Hoq
Arif Hoq on 15 Mar 2022
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
  1 Comment
Lilya
Lilya on 16 Mar 2022
Thanks Arif.. appreciated

Sign in to comment.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by