Time stamp definition in Password export File
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
Всички отговори (2)
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.
See also this thread:
- /questions/1362419 Window 10 Firefox login table date scientific number conversion to Excel date numbers