How to find history in specific day?
I want to find history in specific day. But in History window, I only see options such as: Today, yesterday, Last 7 day, Last month.... and have no option for search in specific day. How can I do this?
All Replies (3)
Open up your history in the Library, and then select the toolbar button which has four horizontal lines through it. This will then give you the option to show additional columns in the window. Choose "Most Recent Visit".
You can then sort your history by either using the same menu, or just clicking on the header for the "Most Recent Visit" column. This way, you can find your items for a specific date.
Thanks Scott. But it's difficult and time-consuming if I want to search date long ago. Do you have Idea?
A possibility is to use this NirSoft utility.
You can use the SQLite Manager extension to create the 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:
SELECT datetime(visit_date/1000000,'unixepoch','localtime') AS visit_date, url, title, visit_count, frecency FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','2014-MM-DD 00:00:00')*1000000 AND strftime('%s','2014-MM-DD 23:59:59')*1000000 ORDER BY visit_date, url
The date/time in strftime needs to be entered in UTC Click Run SQL to generate a results list