How to get yr, month, day, hr, min and s stored as separate variables from a serial date number?

Question

Jing Ci Neo 2018-8-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415563-how-to-get-yr-month-day-hr-min-and-s-stored-as-separate-variables-from-a-serial-date-number

评论： Jing Ci Neo 2018-8-21

I have a vector of serial date numbers (such as 37987.0108217593) and I need to convert each one into year, month, day hr, min second. Example 37987.0108217593 would be year=2004, month=1, day=2, hour=0, min=29 and seconds=20. So I would have a vector called year, a vector called month etc.

Any help will be greatly appreciated!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Steven Lord 2018-8-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415563-how-to-get-yr-month-day-hr-min-and-s-stored-as-separate-variables-from-a-serial-date-number#answer_333462

在 MATLAB Online 中打开

That's close to what you get using the Excel datetime type, but not quite.

>> D = datetime( 37987.0108217593, 'ConvertFrom', 'excel')
D = 
    datetime
     01-Jan-2004 00:15:35

When I paste that number into an Excel worksheet and format it as a Date, the result matches D rather than the information you posted.

If you really do need the datetime broken into its constituent parts you can use the datevec function on D, but there may be a way to achieve your ultimate goal without needing to perform this splitting. If you describe how you want to use this data we may be able to offer suggestions for how to achieve your goal without datevec.

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

Steven Lord 2018-8-20

Which release are you using? If you're using release R2013b or later, consider reading your data in using readtable instead of xlsread. If you do, depending on which release you're using you may be able to read the dates into a table directly from Excel using the 'DatetimeType', 'exceldatenum' name-value pair argument.

Jing Ci Neo 2018-8-21