Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Jul 21, 2019 3:57 PM

Reply
Question marked as Best reply

Posted on Jul 22, 2019 4:27 AM

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).

4 replies
Question marked as Best reply

Jul 22, 2019 4:27 AM in response to PeterandLaurie__

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).

History time stamp

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.