Windows 10 reached EOS (end of support) on October 14, 2025. If you are on Windows 10, 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 freagra
  • 0 leis an bhfadhb seo
  • 171 views
  • Freagra is déanaí ó TyDraniu

ab2qik
ab2qik

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 10 Contributor

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
Cuir ceist

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