how convert 13 digits of timestamp?
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
nada ali
le 5 Juil 2015
Réponse apportée : Walter Roberson
le 8 Juil 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 commentaires
Stephen23
le 7 Juil 2015
Modifié(e) : Stephen23
le 7 Juil 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.
Réponse acceptée
Walter Roberson
le 8 Juil 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 commentaires
Plus de réponses (1)
Azzi Abdelmalek
le 5 Juil 2015
Modifié(e) : Azzi Abdelmalek
le 5 Juil 2015
use
format short
or
s=1238536800000
fprintf('%6.6g\n',s)
0 commentaires
Voir également
Catégories
En savoir plus sur Dates and Time dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!