Caută ajutor

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Acest fir de discuție a fost arhivat. Adresează o întrebare nouă dacă ai nevoie de ajutor.

Time stamp definition in Password export File

  • 2 răspunsuri
  • 2 au această problemă
  • 8 vizualizări
  • Ultimul răspuns de cor-el

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

Toate răspunsurile (2)

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.

more options

See also this thread:

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