We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

Kërkoni te Asistenca

Shmangni karremëzime gjoja asistence. S’do t’ju kërkojmë kurrë të bëni një thirrje apo të dërgoni tekst te një numër telefoni, apo të na jepni të dhëna personale. Ju lutemi, raportoni veprimtari të dyshimtë duke përdorur mundësinë “Raportoni Abuzim”.

Mësoni Më Tepër

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

  • 2 përgjigje
  • 1 e ka hasur këtë problem
  • 5 parje
  • Përgjigjja më e re nga cor-el

more options

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?

Krejt Përgjigjet (2)

more options

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.

more options

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