Chrome时间戳记的格式是什么? [英] What is the format of Chrome's timestamps?
问题描述
我正在使用SQLite数据库浏览器从包含Google Chrome浏览历史的数据库中读取信息.我正在执行SQL"面板中执行的当前代码如下:
I'm using SQLite Database Browser to read information from a database containing the browsing history for Google Chrome. My current code that I am executing in the "Execute SQL" panel looks like this:
SELECT last_visit_time,url,title
FROM urls
WHERE url LIKE {PLACEHOLDER} AND title LIKE {PLACEHOLDER}
出于隐私目的,用{PLACEHOLDER}
阻止了"WHERE"行中的内容.现在,我要使其可读,以使last_visit_time
列中返回的数据可读,而不是像13029358986442901
这样混乱的混乱.我该如何做以及如何将Chrome的时间戳转换为可读格式?如何通过last_visit_time
对它们(返回的行)进行排序?
The stuff on the "WHERE" line is blocked out with {PLACEHOLDER}
for privacy purposes. Now, I want to make it such that the data returned in the last_visit_time
column is readable instead of a jumbled mess like 13029358986442901
. How do I do this and how do I convert Chrome's timestamp to a readable format? How do I get it to order them (the returned rows) by last_visit_time
?
推荐答案
The answer is given in this question: "[Google Chrome's] timestamp is formatted as the number of microseconds since January, 1601"
例如,在我的样本历史记录数据库中,查询
So for example in my sample history database, the query
SELECT
datetime(visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch', 'localtime')
FROM visits
ORDER BY visit_time DESC
LIMIT 10;
给出结果:
2014-09-29 14:22:59
2014-09-29 14:21:57
2014-09-29 14:21:53
2014-09-29 14:21:50
2014-09-29 14:21:32
2014-09-29 14:21:31
2014-09-29 14:16:32
2014-09-29 14:16:29
2014-09-29 14:15:05
2014-09-29 14:15:05
使用您的时间戳记值13029358986442901:
Using your timestamp value of 13029358986442901:
SELECT
datetime(13029358986442901 / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch', 'localtime')
结果是:
2013-11-19 18:23:06
这篇关于Chrome时间戳记的格式是什么?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!