SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','2011-04-01')*1000000 AND strftime('%s','2011-04-30')*1000000

You need to scroll down through the history until you arrive there or try to formulate a query to select that date. *https://developer.mozilla.org/en/Places_query_URIs ---- You can also use the SQLite Manager extension to create list * SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/ # Open Profile Directory -> places.sqlite -> Go # Hit the Execute SQL tab # Use a Select like this: <pre><nowiki>SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','2011-04-01')*1000000 AND strftime('%s','2011-04-30')*1000000 </nowiki></pre> That query shows all history entries from April<br /> The date and time is saved in 64 bit EPOCH format in micro seconds. * http://en.wikipedia.org/wiki/Unix_time ..........<br /> *http://www.sqlite.org/lang.html *http://www.sqlite.org/lang_select.html *http://www.sqlite.org/lang_select.html#fromclause *http://www.sqlite.org/lang_select.html#whereclause *http://www.sqlite.org/lang_expr.html#between