Avatar for Username

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

How do I decode the Last_Date_ Visited field in the places.sqlite db?

  • 3 replies
  • 1 has this problem
  • 770 views
  • Last reply by cor-el

AlanMcGee
AlanMcGee

I opened the places.sqlite file in Firefox SQLite Manager plug in. I can see the Last_Date_Visited field and can see it is a very large Integer. I need to be able to decode the date and time out of this field for a Human Resources matter. Thanks

I opened the places.sqlite file in Firefox SQLite Manager plug in. I can see the Last_Date_Visited field and can see it is a very large Integer. I need to be able to decode the date and time out of this field for a Human Resources matter. Thanks

Chosen solution

Try using this time converter.
http://www.esqsoft.com/javascript_examples/date-to-epoch.htm
Put that integer in Option 2 and hit To Date

Read this answer in context 👍 1

All Replies (3)

the-edmeister
the-edmeister
  • Moderator

Chosen Solution

Try using this time converter.
http://www.esqsoft.com/javascript_examples/date-to-epoch.htm
Put that integer in Option 2 and hit To Date

philipp
philipp
  • Moderator

hello AlanMcGee, you can use a site like www.epochconverter.com in order to convert the timestamps into a human-readable format.

edit: ed was faster on the reply button :-)

Modified by philipp

cor-el
cor-el
  • Top 25 Contributor
  • Moderator

You can also consider to run a query in the SQLite Manager extension to decode an entry.
You can add more columns as required and adjust the like parameter. 

SELECT datetime(visit_date/1000000,'unixepoch') AS visit_date, url, title, visit_count, frecency
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%google.com%'