Cookies expiration time format

Question

I created DB from google chrome's Cookies file and one of the columns in the cookies table is expires_utc. The format of the column is like - 13169399213145330, which is more like unix time. But when i'm trying to use unix time converter, it gives wrong values.

So, what format is that and how i can convert it to actually unix time?

score 14 · Accepted Answer · answered Apr 20 '17 at 12:49

14

So, after long researches on this topic, here is the solution:

Chrome's cookies timestap's epoch starts 1601-01-01T00:00:00Z (Why? Because.)

So, it's 11644473600 seconds before the UNIX epoch. To convert chrome's timestamp to UNIX, you need to:

Devide the actual timestamp (in my case it's expires_utc column in cookies table) by 1000000 // And someone should explain my why.
Subtract 11644473600
DONE! Now you got UNIX timestamp.

answered Apr 20 '17 at 12:49

Src

5,252
5
28
56

Thanks for this! About the divide by 1.000.000 - it's probably because it is in milliseconds – Visti K Feb 04 '20 at 12:52
2

actually it's microseconds und by dividing it by 1M you get seconds. – BergListe Jun 11 '20 at 17:48
Here's more info on the how and why of the 1601/1/1, it's not random :) https://stackoverflow.com/questions/10849717/what-is-the-significance-of-january-1-1601 – Sander van den Oord Jan 19 '23 at 12:00

Cookies expiration time format

1 Answers1

Linked