View Single Post
Old 06-01-2014, 06:33 PM   #1
patou454
Junior Member
patou454 began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Jun 2014
Device: Sony PRS-T1
Get reading time statistics of books

Hey all, i`m new here.

Is it possible to extract reading time statistics from the books.db file using SQliteSpy on the sony prs-t1? My device is not rooted.

I can get the reading_time from the books.db, however how do I convert this twelve character string into time format?

Here is a sample reading_time string from a book I have read: 1346485957321

I`ve tried running this, but it gives me giberish
SELECT strftime("%H:%M:%S", reading_time string );

Any ideas? Getting reading statistics would be great. I would like to know the time spent reading each book.

thanks in advance
patou454 is offline   Reply With Quote