how convert 13 digits of timestamp?
7 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
nada ali
am 5 Jul. 2015
Beantwortet: Walter Roberson
am 8 Jul. 2015
*hi,
how convert 13 digits of timestamp like 1238536800000 into small number with 6 digits It is easy to deal with it.
THANKS *
7 Kommentare
Stephen23
am 7 Jul. 2015
Bearbeitet: Stephen23
am 7 Jul. 2015
@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.
Akzeptierte Antwort
Walter Roberson
am 8 Jul. 2015
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.
0 Kommentare
Weitere Antworten (1)
Azzi Abdelmalek
am 5 Jul. 2015
Bearbeitet: Azzi Abdelmalek
am 5 Jul. 2015
use
format short
or
s=1238536800000
fprintf('%6.6g\n',s)
0 Kommentare
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!