When I look at cookies.sqlite, how do I read the numbers under last accessed, expiry, and creation time?
Under the column "expiry" it reads: 1691890990 Under the column "lastAccessed" it reads: 1484536794500550 Under the column "creationTime" it reads: 1376530990050796
Under the column "expiry" it reads: 1691890990
Under the column "lastAccessed" it reads: 1484536794500550
Under the column "creationTime" it reads: 1376530990050796
Chosen solution
The 16 character strings are date-time stamps in microseconds in Unix epoch format.
The shorter expiry values are likely a count in milliseconds (days: xxx/(24*60*60*1000)).
Possible JavaScript bookmarklet to convert the 16 character strings:
javascript:(function(){var D='',d=new Date(),n; do{n=parseInt(D);d.setTime(isNaN(n)?d.getTime():n/1000);D=prompt('EPOCH (microseconds)\nClick Cancel to Stop\n\n'+D+'\n'+d.toLocaleString()+'\n'+(d.getTime()*1000),d.toUTCString());}while(D!=null);})();
Read this answer in context
👍 3
All Replies (1)
Chosen Solution
The 16 character strings are date-time stamps in microseconds in Unix epoch format.
The shorter expiry values are likely a count in milliseconds (days: xxx/(24*60*60*1000)).
Possible JavaScript bookmarklet to convert the 16 character strings:
javascript:(function(){var D='',d=new Date(),n; do{n=parseInt(D);d.setTime(isNaN(n)?d.getTime():n/1000);D=prompt('EPOCH (microseconds)\nClick Cancel to Stop\n\n'+D+'\n'+d.toLocaleString()+'\n'+(d.getTime()*1000),d.toUTCString());}while(D!=null);})();
Modified by cor-el