Convert from Microsoft's DateTime Structure to readable date
显示 更早的评论
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?
采纳的回答
José-Luis
2014-6-11
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 个评论
Tim
2014-6-11
José-Luis
2014-6-11
What do you mean?
datevec(double(datenum(1,1,0) + int64(635364711800000000) / (86400 * 10^7)))
Tim
2014-6-11
José-Luis
2014-6-11
My bad, didn't remember that you get rid of the fractional part when you divide an integer. Please try:
numDays = double(int64(635364711800000000) / int64(86400 * 10^7))
remainder = double(mod(int64(635364711800000000) , int64(86400*10^7)))
datevec(datenum(1,1,0) + numDays + remainder / (10^7*86400))
Tim
2014-6-11
José-Luis
2014-6-11
My pleasure.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息
Translated by 
