how convert 13 digits of timestamp?

6 次查看（过去 30 天）

显示更早的评论

nada ali 2015-7-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/228436-how-convert-13-digits-of-timestamp

回答： Walter Roberson 2015-7-8

采纳的回答： Walter Roberson

*hi,

how convert 13 digits of timestamp like 1238536800000 into small number with 6 digits It is easy to deal with it.

THANKS *

7 个评论
显示 5更早的评论隐藏 5更早的评论

Stephen23 2015-7-7

编辑：Stephen23 2015-7-7

@nada ali: what epoch and increment does that timestamp have? Without knowing what time system or encoding this timestamp uses, your question is impossible to answer.

nada ali 2015-7-7

编辑：nada ali 2015-7-7

thanks I just found the dataset with the following format including timestamp

*userID artistID tagID timestamp

2 52 13 1238536800000

2 52 15 1238536800000

2 52 18 1238536800000

2 52 21 1238536800000

2 52 41 1238536800000*

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2015-7-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/228436-how-convert-13-digits-of-timestamp#answer_185339

Divide the 13 digit timestamp by 1000 to get seconds. Divide by 24 * 60 * 60 to get days. Add datenum('1970-1-1'). The result will be a MATLAB date number.

This task would have been easier if you had identified the source of the data; I tracked it down by searching on the heading you provided and showed that it was an extract of last.fm data. After that it was a matter of researching to find out what timestamp format that last.fm used. When that was unsuccessful I took a sample timestamp from the last.fm site and googled it and was fortunate to find a discussion about Drupal in which someone was asking about proper conversion of the timestamp, and that gave me a target date to reverse-engineer from. The rest was based upon my historical knowledge of Unix timestamps starting at January 1 1970.