Pretraži podršku

Izbjegni prevare podrške. Nikad te nećemo tražiti da nas nazoveš, da nam pošalješ telefonski broj ili da podijeliš osobne podatke. Prijavi sumnjive radnje pomoću opcije „Prijavi zlouporabu”.

Saznaj više

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

  • 2 odgovora
  • 1 ima ovaj problem
  • 5 prikaza
  • Posljednji odgovor od 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?

Svi odgovori (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