How to get yr, month, day, hr, min and s stored as separate variables from a serial date number?
1 view (last 30 days)
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!
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')
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.