Android Browser History Parser Error
sambrothers opened this issue · 2 comments
sambrothers commented
Dates in the DB I have are in unix milliseconds. The parser used Google Time and reports the incorrect time.
Currently: DateTime("history"."date" / 1000000 - 11644473600, 'unixepoch') || " UTC" AS "Last Time Visited"
Should be: DateTime("history"."date" / 1000, 'unixepoch') || " UTC" AS "Last Time Visited",
-Sam
den4uk commented
Hi Sam,
Many thanks for the bug report. This is an easy fix, and will be changed to unix ms time in version 3.4.1.
Cheers
Denis