Mozilla will shut down Pocket’s services on July 8, 2025. At that time users will no longer be able to access the Pocket website, apps and API. You can export your saved items and API data until October 8, 2025 before they are permanently removed. For more information, see this article.

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
  • 740 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
  • 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%'