Avatar for Username

Pomoc přepytać

Hladajće so wobšudstwa pomocy. Njenamołwimy was ženje, telefonowe čisło zawołać, SMS pósłać abo wosobinske informacije přeradźić. Prošu zdźělće podhladnu aktiwitu z pomocu nastajenja „Znjewužiwanje zdźělić“.

Dalše informacije

Tuta nitka je so archiwowała. Prošu stajće nowe prašenje, jeli pomoc trjebaće.

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

  • 3 wotmołwy
  • 2 matej tutón problem
  • 1 napohlad
  • Poslednja wotmołwa wot 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.

Wot graciesmoxie změnjeny

Wšě wotmołwy (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?