X
Нажмите здесь, чтобы перейти на мобильную версию сайта.

Форум поддержки

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

Размещено

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

Выбранное решение

Дополнительные сведения о системе

Установленные плагины

  • Shockwave Flash 11.8 r800
  • Google Update
  • GEPlugin
  • npsitesafety
  • Adobe PDF Plug-In For Firefox and Netscape 10.1.4
  • NPRuntime Script Plug-in Library for Java(TM) Deploy
  • Next Generation Java Plug-in 10.4.1 for Mozilla browsers
  • DRM Netscape Network Object
  • Npdsplay dll
  • DRM Store Netscape Plugin
  • Package Installer & Install Conduit

Приложение

  • User Agent: Mozilla/5.0 (Windows NT 5.1; rv:23.0) Gecko/20100101 Firefox/23.0

Дополнительная информация

the-edmeister
  • Top 25 Contributor
  • Moderator
5387 решений 39986 ответов
Размещено

Выбранное решение

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

Try using this time converter. <br /> http://www.esqsoft.com/javascript_examples/date-to-epoch.htm <br /> Put that integer in Option 2 and hit '''To Date'''
philipp
  • Top 25 Contributor
  • Moderator
5264 решений 23279 ответов
Размещено

Полезный ответ

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

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 :-)''

Изменено philipp

cor-el
  • Top 10 Contributor
  • Moderator
17267 решений 156032 ответов
Размещено

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%'
You can also consider to run a query in the SQLite Manager extension to decode an entry.<br /> You can add more columns as required and adjust the like parameter. <pre><nowiki>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%'</nowiki></pre> * http://www.sqlite.org/lang_expr.html#like