Avatar for Username

تلاش سپورٹ

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.

مزید سیکھیں

اس تھریڈ کو آرکائیوکیا گیا تھا۔ اگر آپ کو مدد کی ضرورت ہو تو براہ مہربانی نیا سوال پوچھیں۔

I need help I want to analyze and create reports using data from my firefox history files .

  • 3 جواب دیں
  • 2 میں یہ مسئلہ ہے
  • 1 دیکھیں
  • آخری جواب بذریعہ n8chz

graciesmoxie
graciesmoxie
more options

I am not quite sure where to post this. I had a program for analyzing my firefox history which no longer works due to the change in how firefox stores history data. I am not an sqlite user. Any help will be greatly appreciated. I downloaded the sqlite manager addon and it is now installed on my firefox browser. I have tried it out and can make some sense of it. I would like to know how to decode the time/date storage system.

I am not quite sure where to post this. I had a program for analyzing my firefox history which no longer works due to the change in how firefox stores history data. I am not an sqlite user. Any help will be greatly appreciated. I downloaded the sqlite manager addon and it is now installed on my firefox browser. I have tried it out and can make some sense of it. I would like to know how to decode the time/date storage system.

graciesmoxie کی جانب سے میں ترمیمکی گئ

تمام جوابات (3)

the-edmeister
the-edmeister
  • Moderator
more options

It uses Unix time, which is the number of seconds that have elapsed since January 1, 1970 00:00 UTC /GMT.

http://en.wikipedia.org/wiki/Unix_time
Here is an online converter tool for Unix times.
http://www.esqsoft.com/javascript_examples/date-to-epoch.htm

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

Firefox stores the dates in microseconds in the SQLite files, so you may need to leave some digits to make the online converter work.

n8chz
n8chz
more options

It seems JavaScript counts milliseconds, while SQLite wants whole seconds. Can I assume that placing Math.round((new Date()).getTime()/1000) in a SQLite INTEGER cell will produce appropriate results with SQLite's date manipulation features?