Avatar for Username

Search Support

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

Lolu chungechunge lwabekwa kunqolobane. Uyacelwa ubuze umbuzo omusha uma udinga usizo.

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

  • 3 uphendule
  • 2 zinale nkinga
  • 1 view
  • Igcine ukuphendulwa ngu 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.

Okulungisiwe ngu 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?