how convert 13 digits of timestamp?
6 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
nada ali
il 5 Lug 2015
Risposto: Walter Roberson
il 8 Lug 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 Commenti
Stephen23
il 7 Lug 2015
Modificato: Stephen23
il 7 Lug 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.
Risposta accettata
Walter Roberson
il 8 Lug 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 Commenti
Più risposte (1)
Azzi Abdelmalek
il 5 Lug 2015
Modificato: Azzi Abdelmalek
il 5 Lug 2015
use
format short
or
s=1238536800000
fprintf('%6.6g\n',s)
0 Commenti
Vedere anche
Categorie
Scopri di più su Dates and Time in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!