Converting date into date and hours

Question

zafar khan 2017-9-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/357772-converting-date-into-date-and-hours

回答： Peter Perkins 2017-9-21

I have half hourly energy data and need to convert the date into hourly format. At present the date is dd/mm/yyyy and hour is 0.5,1.0,1.5,... I want to get it as yyyy-mm-dd HH:MM:SS Any idea how to do it??

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

James Tursa 2017-9-21

Please be more specific. What is the exact format of your input data (the date and hour data)? Character string array and double array? Cell arrays? Or ...? And what do you want for the result ... a cell array of character strings? Or ...?

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2017-9-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/357772-converting-date-into-date-and-hours#answer_282598

在 MATLAB Online 中打开

Use datetimes and durations:

>> t0 = datetime('today','Format','yyyy-MM-dd HH:mm:ss')
t0 = 
  datetime
   2017-09-21 00:00:00
>> t = t0 + hours(0:.5:3)'
t = 
  7×1 datetime array
   2017-09-21 00:00:00
   2017-09-21 00:30:00
   2017-09-21 01:00:00
   2017-09-21 01:30:00
   2017-09-21 02:00:00
   2017-09-21 02:30:00
   2017-09-21 03:00:00