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

Avatar for Username

ابحث في الدعم

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 (رد واحد)
  • 0 have this problem
  • 26 views
  • آخر ردّ كتبه 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 10 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
اطرح سؤالا

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