Does anyone know how to save and print Firefox history that also shows the time and date info on a Mac? I tried using SQLite Manager, but can’t figure out how to use it.
Did you find the suggestions above helpful? Let us know.
Okay, we're getting a little out of my league here, but I'll try to help. Here's what I found while playing around, please let me know if it helps you.
SELECT * FROM DATE_SAMPLE
WHERE SAMPLE_DATE >= '2003-04-09'
AND SAMPLE_DATE =) expression instead of just greater than (>). If only the greater than sign was used the SELECT statement would not return record 4. This record would not be returned because when SQL Server converts the string '2003-04-09' to a date/time value it would be equal to the SAMPLE_DATE on record 4.
Using the DATEPART Function:
Another way to return the records that have a SAMPLE_DATE for a particular date is to use the DATEPART function. With the DATEPART function you can build a WHERE statement that breaks apart each piece (year, month, day) of the SAMPLE_DATE and verifies that each piece is equal to the year, month and day you are looking for. Below, is a DATEPART example that once again returns all the records that have a SAMPLE_DATE in '2003-04-09'.
SELECT * FROM DATE_SAMPLE
DATEPART(YEAR, SAMPLE_DATE) = '2003' AND
DATEPART(MONTH,SAMPLE_DATE) = '04' AND
DATEPART(DAY, SAMPLE_DATE) = '09'
Using the FLOOR Function:
As I have said before there are many ways to accomplish the same thing. Here is a method that uses the FLOOR and CAST function to truncate the time portion from a date. The inner CAST function converts a DATETIME variable into a decimal value, then the FLOOR function rounds it down to the nearest integer value, and then the outer CAST function does the final conversion of the integer value back to a DATETIME value.
SELECT * FROM DATE_SAMPLE WHERE
CAST(FLOOR(CAST(SAMPLE_DATE AS FLOAT))AS DATETIME) =
Using the LIKE clause:
The LIKE clause can also be used to search for particular dates, as well. You need to remember that the LIKE clause is used to search character strings. Because of this the value which you are searching for will need to be represented in the format of an alphabetic date. The correct format to use is: MON DD YYYY HH:MM:SS.MMMAM, where MON is the month abbreviation, DD is the day, YYYY is the year, HH is hours, MM is minutes, SS is seconds, and MMM is milliseconds, and AM designates either AM or PM.
The LIKE clause is somewhat easy to use because you can use the wildcard to select all the records in a particular month, AM or PM records, a particular day, and what not. Again using our DATE_SAMPLE table above, let me show you how the return records using the LIKE clause.
Say you want to return all the records with a SAMPLE_DATE in '2003-04-09'. In that case, your SQL Statement would look like so:
SELECT * FROM DATE_SAMPLE WHERE SAMPLE_DATE LIKE 'Apr 9 2003%'
Note the month is specified as "Apr", instead of using the numeric "04" value for April. This SELECT statement, similar to the ones I showed earlier, returns records 4 through 7.
Now, say you want to return all the records for April 2003. In this case, you would issues the following statement:
SELECT * FROM DATE_SAMPLE WHERE SAMPLE_DATE LIKE 'Apr%2003%'
This statement would return records 3 through 9 from the DATE_SAMPLE table.
If you would like to return any record that has a SAMPLE_DATE in April regardless of the year, then the LIKE statement makes this easy. The following statement uses the LIKE clause to retrieve not only the 2003 records, but also the one record in table DATE_SAMPLE for 2002.
SELECT * FROM DATE_SAMPLE WHERE SAMPLE_DATE LIKE 'Apr%'
The above statement would return records 2 through 9.
If you wanted to return all the records that have a PM designation (RECORD's 2,3,6 and 7), you could do this easily using the following LIKE clause:
SELECT * FROM DATE_SAMPLE WHERE SAMPLE_DATE LIKE '%PM'
As you can see, the LIKE statement allows you another alternative to search the database for records with a particular date criteria that supports wildcard characters.
Hello, have you tried exporting your history? You can import or export your history to a file with the html format. To do so, here is the process:
-- Open firefox
-- click on the history button >> pick show all history
-- click on the views button >> select the show columns and check what you want it to show or
-- click on the views button >> sort >> highlight and click on what you want it to show
-- Once the history shows, click on the Import and backup button
-- click on the export HTML
-- Save it to a place of your choosing
-- open html file
-- go to file >> print
Also you can read the content of the following link:
That will actually save your bookmarks not your history.
If your using version 3, you might be able to change the about:config to accomplish what you are trying to do.
Which version of Firefox are you using? This will not work with version 3.
This is how you can print Firefox history (on MacOS but should work on other platforms)
1) Download and install SQLite Manager FF plugin
2) Open SQLite Manager from the tools menu
3) Open places.sqlite from your-home/Library/Application Support/Firefox/profiles/your.profile/
4) Hit the Execute SQL tab
5) Use a select similar to this.....
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 url LIKE '%youtube%'
6) Click the actions dropdown to export to CSV
Hope this helps