Avatar for Username

Search Support

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

This thread was archived. Please ask a new question if you need help.

Time stamp definition in Password export File

  • 2 replies
  • 2 have this problem
  • 13 views
  • Last reply by 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

All Replies (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