X
Thinta lapha ukuze uye kuveshini yamakhalekhukhwini kusayithi.

Isithangami Sabeseki

Lolu chungechunge lwabekwa kunqolobane. Uyacelwa ubuze umbuzo omusha uma udinga usizo.

need help pulling up history on specific date

Kuphostiwe

i am trying to pull up history for a certain day in april..in the drop down menu april is not an option..today, last 7 days, last month or longer than 6 months..how can i pull up APRIL???

i am trying to pull up history for a certain day in april..in the drop down menu april is not an option..today, last 7 days, last month or longer than 6 months..how can i pull up APRIL???

Eminye Imininingwane Yohlelo

Fakela amapulagi

  • Gecko default plugin
  • Runs Java applets using the latest installed versions of Java. For more information: Java Embedding Plugin. Run version test: Java Information.
  • http://www.facebook.com/fbplugin/
  • Java 1.3.1 Plug-in
  • Netscape plug-in that plays Rhapsody content
  • DivX Content Upload Plug-In: Uploads DivX video in your browser!
  • DivX Browser Plug-In: Plays DivX video in your browser!
  • Yahoo! Installer Plug-in provides application installation support
  • The Flip4Mac WMV Plugin allows you to view Windows Media content using QuickTime.
  • Adobe Shockwave for Director Netscape plug-in, version 11.0.0
  • Office Live Update v1.0
  • The Google Earth Plugin allows you to view 3D imagery and terrain in your web browser.
  • Shockwave Flash 10.1 r85
  • The QuickTime Plugin allows you to view a wide variety of multimedia content in web pages. For more information, visit the QuickTime Web site.

Isisebenziso

  • I-ejenti Engumsebenzisi: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.4; en-US; rv:1.9.2.17) Gecko/20110420 YFF35 Firefox/3.6.17

Eminye Imininingwane

cor-el
  • Top 10 Contributor
  • Moderator
17583 izisombululo 159079 izimpendulo
Kuphostiwe

Impendulo Ewusizo

You need to scroll down through the history until you arrive there or try to formulate a query to select that date.


You can also use the SQLite Manager extension to create list

  1. Open Profile Directory -> places.sqlite -> Go
  2. Hit the Execute SQL tab
  3. Use a Select like this:
SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','2011-04-01')*1000000 AND strftime('%s','2011-04-30')*1000000

That query shows all history entries from April
The date and time is saved in 64 bit EPOCH format in micro seconds.

..........

You need to scroll down through the history until you arrive there or try to formulate a query to select that date. *https://developer.mozilla.org/en/Places_query_URIs ---- You can also use the SQLite Manager extension to create list * SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/ # Open Profile Directory -> places.sqlite -> Go # Hit the Execute SQL tab # Use a Select like this: <pre><nowiki>SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','2011-04-01')*1000000 AND strftime('%s','2011-04-30')*1000000 </nowiki></pre> That query shows all history entries from April<br /> The date and time is saved in 64 bit EPOCH format in micro seconds. * http://en.wikipedia.org/wiki/Unix_time ..........<br /> *http://www.sqlite.org/lang.html *http://www.sqlite.org/lang_select.html *http://www.sqlite.org/lang_select.html#fromclause *http://www.sqlite.org/lang_select.html#whereclause *http://www.sqlite.org/lang_expr.html#between

Okulungisiwe ngu cor-el