History time stamp
How can I obtain the time stamp on when a website was visited?
macOSMojave
iMac with Retina 5K display, macOS 10.14
How can I obtain the time stamp on when a website was visited?
macOSMojave
iMac with Retina 5K display, macOS 10.14
Do you mean time expressed in hours : minutes : seconds? Unfortunately Safari doesn't show the time. The entire browsing history available in History -> Show All History menu shows only the date.
The history is saved in a database file named History.db located in Safari folder inside your Library. If you're familiar with SQL you can copy that database file somewhere, open it with the app DB Browser for SQLite, choose Browse Data and select under the Table dropdown menu history_visits. You can sort the data selecting the visit_time column.
The problem is that the timestamp in that column is expressed in Core Data timestamp format which is not human readable. You can convert it here: https://www.epochconverter.com/coredata
If you need to check only a specific visit it's doable otherwise you'd need to convert someway the entire column (I guess exporting the table in CSV and managing the conversion with another app).
Do you mean time expressed in hours : minutes : seconds? Unfortunately Safari doesn't show the time. The entire browsing history available in History -> Show All History menu shows only the date.
The history is saved in a database file named History.db located in Safari folder inside your Library. If you're familiar with SQL you can copy that database file somewhere, open it with the app DB Browser for SQLite, choose Browse Data and select under the Table dropdown menu history_visits. You can sort the data selecting the visit_time column.
The problem is that the timestamp in that column is expressed in Core Data timestamp format which is not human readable. You can convert it here: https://www.epochconverter.com/coredata
If you need to check only a specific visit it's doable otherwise you'd need to convert someway the entire column (I guess exporting the table in CSV and managing the conversion with another app).
Thanks VikingOSX for the feedback.
What I've noticed is that the database is not updated with the last visits (at least 50 recent visits are missing).
The timestamps, though, seem correct to me. I've checked randomly just o few of them and the provided time seems credible.
How can I obtain the time stamp on when a website was visited?
I found that even the Sqlite3 function localtime does not get the time portion of that history date correct either, even when inside history.db. Fun stuff.
History time stamp