Zum Hauptinhalt springen

Schlagwort: Sqlite

Querying browser history in 16th century

As of this answert to the popular question, the data model of the Chrome or Chromium Browser stores timestamp as the number of microseconds since first of January, 1601.

Therefore an valid SQL query to search for visits betwen two dates looks like this:

SELECT v_time, urls.url, urls.title FROM 
  (SELECT
    url,
    datetime(visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch', 'localtime') as v_time
  FROM visits
  ORDER BY visit_time DESC) as X
    LEFT JOIN urls ON X.url = urls.id
    WHERE X.v_time > '2023-09-27' 
      AND X.v_time < '2023-09-30';