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

1 view (last 30 days)
Jing Ci Neo
Jing Ci Neo on 20 Aug 2018
Commented: Jing Ci Neo on 21 Aug 2018
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!

Accepted Answer

Steven Lord
Steven Lord on 20 Aug 2018
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 Comments
Jing Ci Neo
Jing Ci Neo on 21 Aug 2018
I wasn't able to use readtable successfully but managed to manipulate the data in excel. Thanks for your help anyway! I really appreciate it.

Sign in to comment.

More Answers (0)

Tags

Products


Release

R2016a

Community Treasure Hunt

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

Start Hunting!