Chrome 的时间戳格式是什么?

2022-01-13 00:00:00 timestamp google-chrome sqlite

我正在使用 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}

出于隐私目的，WHERE"行中的内容被 {PLACEHOLDER} 屏蔽.现在，我想让 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?

推荐答案

答案在这个问题: "[Google Chrome's] 时间戳被格式化为自 1601 年 1 月以来的微秒数"

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

相关文章