This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

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.

Learn More

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

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

  • 3 ردود
  • 2 have this problem
  • 1 view
  • آخر ردّ كتبه 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.

Modified by graciesmoxie

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