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.

مزید سیکھیں

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

need help pulling up history on specific date

  • 1 جواب دیں
  • 6 میں یہ مسئلہ ہے
  • 6 دیکھیں
  • آخری جواب بذریعہ cor-el

uclafrk1
uclafrk1
more options

i am trying to pull up history for a certain day in april..in the drop down menu april is not an option..today, last 7 days, last month or longer than 6 months..how can i pull up APRIL???

i am trying to pull up history for a certain day in april..in the drop down menu april is not an option..today, last 7 days, last month or longer than 6 months..how can i pull up APRIL???

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

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

You need to scroll down through the history until you arrive there or try to formulate a query to select that date.

You can also use the SQLite Manager extension to create list

  1. Open Profile Directory -> places.sqlite -> Go
  2. Hit the Execute SQL tab
  3. Use a Select like this: 
SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','2011-04-01')*1000000 AND strftime('%s','2011-04-30')*1000000

That query shows all history entries from April
The date and time is saved in 64 bit EPOCH format in micro seconds.

..........

cor-el کی جانب سے میں ترمیمکی گئ