NOT SOLVED: Translating visit_time in History to Human-Readable Format

Brave Browser stores browser history in a sql lite database. Each visit to a url is recorded in a table called visits. One of the fields in that table is visit_time.

QUESTION: How is visit time converted to human-readable format?

For example, here is the data for the visit made to the Brave Community where I am typing this new topic:

URL: https://community.brave.com/search?q=history%20category%3A48
visit_time: 13250627305551448

In the Brave Browser history, that history record looks like this:

In SQL Lite, the data looks like this:

1 Like

this the time since 1/1/1970 in sec

use this site to convert it

hope it help and have a nice day

2 Likes

.
.
.
.
Unfortunately, I am unable to obtain a verifiable result when computing the date by counting seconds since January 1, 1970.

I tried four different ways starting with epochconverter .com:
.
At epochconverter .com, visit_time 13250627305551448 does not fit into the field for entering a timestamp. It returned a date bearing no discernable correlation to the date when the browser visited the url.
.


Please click on image for better viewing
.
.
.

Please click on image for better viewing
.
.

Please click on image for better viewing
.
.

Please click on image for better viewing

1 Like

This question remains unanswered.

1 Like

You can help solve it by going to one specific page at, lets say 12 noon, then go to a different one at 1pm. Then compare the times. You’ll know pretty close to what an hour value is then. Then work backwards and figure it out. Then come back here, post the result and mark it as the solution.

1 Like

plus what @141 said

i could guess it nansec from the first of installation as this
13250627305551448 = 6 months in nanosec

but what @141 is better way to know the exact unit of it

and have a nice day both of you

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.