Windows 10 reached EOS (end of support) on October 14, 2025. If you are on Windows 10, see this article.

Avatar for Username

Pesquisar no apoio

Evite burlas no apoio. Nunca iremos solicitar que telefone ou envie uma mensagem de texto para um número de telefone ou que partilhe informações pessoais. Por favor, reporte atividades suspeitas utilizando a opção "Reportar abuso".

Saber mais

Esta discussão foi arquivada. Se precisar de ajuda, por favor, coloque uma nova questão.

Time stamp definition in Password export File

  • 2 respostas
  • 2 têm este problema
  • 15 visualizações
  • Última resposta por cor-el
  • Arquivadas

cdonpaul
cdonpaul

I was able to export my user ID and passwords for the sites I visit. There are three time stamps in the file displayed in scientific notation. How is this number translated to the actual date and time? It does not appear to be a Julian date. Thanks

Example timeCreated timeLastUsed timePasswordChanged 1.63E+12 1.64141E+12 1.63E+12 1.567E+12 1.63984E+12 1.567E+12

I was able to export my user ID and passwords for the sites I visit. There are three time stamps in the file displayed in scientific notation. How is this number translated to the actual date and time? It does not appear to be a Julian date. Thanks Example timeCreated timeLastUsed timePasswordChanged 1.63E+12 1.64141E+12 1.63E+12 1.567E+12 1.63984E+12 1.567E+12

Todas as respostas (2)

jscher2000 - Support Volunteer
jscher2000 - Support Volunteer

If you are viewing them in Excel, make the column wider to see the very long number, such as 1641514800982.

These values are in Unix epoch units, so I suspect Excel can't convert them. If you need one or another, you can use a conversion page such as, for example:

https://www.epochconverter.com/

If you need to convert all of them, you will want to find a script for that. Obviously you can't upload this very sensitive file to a website, so it would need to run on your computer.

cor-el
cor-el
  • Top 25 Contributor
  • Moderator

See also this thread:

  • /questions/1362419 Window 10 Firefox login table date scientific number conversion to Excel date numbers