Avatar for Username

Mozilla サポートの検索

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 により に変更されました