Where did you install Firefox from? Help Mozilla uncover 3rd party websites that offer problematic Firefox installation by taking part in our campaign. There will be swag, and you'll be featured in our blog if you manage to report at least 10 valid reports!

Avatar for Username

Hilfe durchsuchen

Vorsicht vor Support-Betrug: Wir fordern Sie niemals auf, eine Telefonnummer anzurufen, eine SMS an eine Telefonnummer zu senden oder persönliche Daten preiszugeben. Bitte melden Sie verdächtige Aktivitäten über die Funktion „Missbrauch melden“.

Learn More

Dieses Thema wurde archiviert. Bitte stellen Sie eine neue Frage, wenn Sie Hilfe benötigen.

Time stamp definition in Password export File

  • 2 Antworten
  • 2 haben dieses Problem
  • 13 Aufrufe
  • Letzte Antwort von cor-el

cdonpaul
cdonpaul
more options

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

Alle Antworten (2)

jscher2000 - Support Volunteer
jscher2000 - Support Volunteer
  • Top 10 Contributor
more options

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
  • Moderator
  • Top 10 Contributor
more options

See also this thread:

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