How to make time string from seconds of each year (total 11 years) to year (for 11 years)

2 次查看(过去 30 天)
Dear all,
I have a time series data set from 2008 to 2019. Where 1st column is for year and 2nd column (time interval is 300 seconds =5 minutes) is for seconds of each year (i,e, for each year time starts from 0000 seconds). But I need to study for 2008 to 2019 (continuously). How can I make continuous time from January, 2008 to December, 2019 with the same interval (5 minutes) of time?
Thanks in advance.

采纳的回答

Voss
Voss 2022-4-16
dt = datetime('2008-01-01 00:00:00'):minutes(5):datetime('2019-12-31 23:55:00');
dt(1:10).'
ans = 10×1 datetime array
01-Jan-2008 00:00:00 01-Jan-2008 00:05:00 01-Jan-2008 00:10:00 01-Jan-2008 00:15:00 01-Jan-2008 00:20:00 01-Jan-2008 00:25:00 01-Jan-2008 00:30:00 01-Jan-2008 00:35:00 01-Jan-2008 00:40:00 01-Jan-2008 00:45:00
dt(end-9:end).'
ans = 10×1 datetime array
31-Dec-2019 23:10:00 31-Dec-2019 23:15:00 31-Dec-2019 23:20:00 31-Dec-2019 23:25:00 31-Dec-2019 23:30:00 31-Dec-2019 23:35:00 31-Dec-2019 23:40:00 31-Dec-2019 23:45:00 31-Dec-2019 23:50:00 31-Dec-2019 23:55:00
  6 个评论
Voss
Voss 2022-4-18
I think using datetime is the best way to go, yes.
You can easily add the seconds 'offset' from the beginning of each year using the seconds function
datetime('2008-01-01')+seconds(300)
ans = datetime
01-Jan-2008 00:05:00
datetime(2008,1,1)+seconds(300) % same
ans = datetime
01-Jan-2008 00:05:00
datetime(2008,1,1)+seconds(300:300:30000).'
ans = 100×1 datetime array
01-Jan-2008 00:05:00 01-Jan-2008 00:10:00 01-Jan-2008 00:15:00 01-Jan-2008 00:20:00 01-Jan-2008 00:25:00 01-Jan-2008 00:30:00 01-Jan-2008 00:35:00 01-Jan-2008 00:40:00 01-Jan-2008 00:45:00 01-Jan-2008 00:50:00 01-Jan-2008 00:55:00 01-Jan-2008 01:00:00 01-Jan-2008 01:05:00 01-Jan-2008 01:10:00 01-Jan-2008 01:15:00 01-Jan-2008 01:20:00 01-Jan-2008 01:25:00 01-Jan-2008 01:30:00 01-Jan-2008 01:35:00 01-Jan-2008 01:40:00 01-Jan-2008 01:45:00 01-Jan-2008 01:50:00 01-Jan-2008 01:55:00 01-Jan-2008 02:00:00 01-Jan-2008 02:05:00 01-Jan-2008 02:10:00 01-Jan-2008 02:15:00 01-Jan-2008 02:20:00 01-Jan-2008 02:25:00 01-Jan-2008 02:30:00

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Dates and Time 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by