Convert from Microsoft's DateTime Structure to readable date
2 views (last 30 days)
Show older comments
I have a dataset with collection intervals marked with numeric identifiers such as the following:
- 635364711700000000 - 635364711800000000 -635364711900000000
These IDs are from Microsoft's DateTime Structure (see link below). Does anybody know if Matlab has functionality to convert from the DateTime Structure to a timestamp in human readable format?
0 Comments
Accepted Answer
José-Luis
on 11 Jun 2014
No, I don't think there is. But if you don't care about leap seconds it is not too complicated:
epoch = datenum(1,1,0);
matlab_time = epoch + MicrosoftTime / (86000 * 10^7); %1 unit Microsoft time = 100 nanoseconds
e.g., taking care of the fact that MicrosftTime should not be stored as double:
datestr(double(datenum(1,1,0) + int64(635364711800000000) / (86400 * 10^7)))
6 Comments
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!