Vyhľadajte odpoveď

Vyhnite sa podvodom s podporou. Nikdy vás nebudeme žiadať, aby ste zavolali alebo poslali SMS na telefónne číslo alebo zdieľali osobné informácie. Nahláste prosím podozrivú aktivitu použitím voľby “Nahlásiť zneužitie”.

Ďalšie informácie

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

  • 2 odpovede
  • 1 má tento problém
  • 3 zobrazenia
  • Posledná odpoveď 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?

Všetky odpovede (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