Windows 10 will reach EOS (end of support) on October 14, 2025. For more information, see this article.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

How to search and filter history in sqlite3?

  • 1 antwoord
  • 0 hierdie probleem
  • 1 view
  • Laaste antwoord deur TyDraniu

ab2qik
ab2qik
more options

How to search and filter history on specific values like url, title, date/time visited in sqlite3?

Thankyou ab2qik.

How to search and filter history on specific values like url, title, date/time visited in sqlite3? Thankyou ab2qik.

All Replies (1)

TyDraniu
TyDraniu
  • Top 25 Contributor
more options

You can use this kind of select: 

SELECT datetime(h.visit_date/1000000,'unixepoch'), p.url, p.title
FROM moz_places p, moz_historyvisits h 
WHERE p.id = h.place_id
Vra 'n vraag

You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.