Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

ძიება მხარდაჭერაში

ნუ გაებმებით თაღლითების მახეში მხარდაჭერის საიტზე. აქ არასდროს მოგთხოვენ სატელეფონო ნომერზე დარეკვას, შეტყობინების გამოგზავნას ან პირადი მონაცემების გაზიარებას. გთხოვთ, გვაცნობოთ რამე საეჭვოს შემჩნევისას „დარღვევაზე მოხსენების“ მეშვეობით.

ვრცლად

Is there anyway I can see the first time I visited a certain website?

  • 2 პასუხი
  • 1 მომხმარებელი წააწყდა მსგავს სიძნელეს
  • 5 ნახვა
  • ბოლოს გამოეხმაურა cor-el

For example: Say I visit google.com for the first time on June 17, 2018 and today I want to see when I visited google for the first time, and see the date I did. Is there anyway to see this information?

For example: Say I visit google.com for the first time on June 17, 2018 and today I want to see when I visited google for the first time, and see the date I did. Is there anyway to see this information?

ყველა პასუხი (2)

As you know, Firefox's Library window only shows the date/time of the last visit, not the date/time of any earlier visits. This data is stored in Firefox (going back a certain amount of time), but in order to extract it, you would need to use an add-on or external program. I'm not familiar with programs for Mac, sorry.

Try this SQLite viewer and drop the places.sqlite file on the page..

Some older threads with possible SQLite code:

  • [/questions/937585] Support for "Date first visited" for history items was removed from Firefox
  • [/questions/931864] Can I access all dates that a website has been visited?
  • [/questions/945090] How can i prevent Firefox from overiding identical history entries?

SELECT url, title, visit_count, datetime(first_visit/1000000,'unixepoch','localtime') AS EarliestVisit, datetime(last_visit_date/1000000,'unixepoch','localtime') AS LatestVisit
FROM moz_places INNER JOIN
 (SELECT place_id, MIN(visit_date) AS first_visit
  FROM moz_historyvisits
  GROUP BY place_id) AS FirstVisits
 ON FirstVisits.place_id = moz_places.id
WHERE url LIKE '%mozilla.org%'
ORDER BY url