Skip to content

Instantly share code, notes, and snippets.

@Unison1
Last active July 17, 2019 11:04
Show Gist options
  • Save Unison1/f83aa1e6cdc7f2320625fc235daf4f82 to your computer and use it in GitHub Desktop.
Save Unison1/f83aa1e6cdc7f2320625fc235daf4f82 to your computer and use it in GitHub Desktop.
Chrome_Time_Convert.sql
SELECT u.url AS [Сайт], u.title AS [Заголовок],
DATETIME(v.visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch','localtime') AS [Дата]
FROM visits AS v
JOIN urls AS u ON v.url = u.id
ORDER BY v.visit_time
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment