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.