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

Avatar for Username

Eheka Pytyvõha

Emboyke pytyvõha apovai. Ndorojeruremo’ãi ehenói térã eñe’ẽmondóvo pumbyrýpe ha emoherakuãvo marandu nemba’etéva. Emombe’u tembiapo imarãkuaáva ko “Marandu iñañáva” rupive.

Kuaave

How to search and filter history in sqlite3?

  • 1 Mbohovái
  • 0 oguereko ko apañuãi
  • 29 Hecha
  • Mbohovái ipaháva TyDraniu

ab2qik
ab2qik
jeporavorãve

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.

Opaite Mbohovái (1)

TyDraniu
TyDraniu
  • Top 10 Contributor
jeporavorãve

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
Eporandumína

Nde eikéke nde mba’etepe embohovái hag̃ua ñe’ẽmondo. Ikatúpa, emoñepyrũ peteĩ porandu, ndereguerekói gueteriramo nemba’ete.