The latest articles on DEV Community by Paul Fenwick (@pf_96da86a2ef1d). https://dev.to/pf_96da86a2ef1d https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F876939%2Fee3be2d4-ad0b-45d7-ab64-68c65346ac22.png https://dev.to/pf_96da86a2ef1d en Paul Fenwick Tue, 14 Jun 2022 09:05:45 +0000 https://dev.to/pf_96da86a2ef1d/ql-to-query-convert-chrome-time-stamp-to-epoch-milliseconds-1jnh https://dev.to/pf_96da86a2ef1d/ql-to-query-convert-chrome-time-stamp-to-epoch-milliseconds-1jnh <p>I am trying query the Chrome history database and return the chromium timestamp as human readable. for example 14/06/2022 10:05:30.25</p> <p>SELECT u.url AS URL, u.title AS Title, u.visit_count As "Visit Count", datetime(u.last_visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch', 'localtime') As "Last Visited Date Time", datetime(v.visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch', 'localtime') AS "Visited Date Time" FROM urls u, visits v WHERE u.id = v.url</p> sql beginners sqlite chrome