0

I was using Viber in both PC (window 7) and Mobile phone. application on my phone and pc has been reinstalled. i cannot retrieve the message history on the viber application for pc. Good thing i have backup copy of the viber messages in my pc viber.db ... I need to retrieve message history for future needs (date , time, mobile no, messages). Hope some one can help. really desperate

What I have tried so far: select timestamp, chattoken, body from eventinfo order by number

But the timestamp is in int not on date format

1 Answer 1

0

Try this query:

select datetime(timestamp, 'unixepoch'), chattoken, body from eventinfo order by timestamp;

You can have a look at "SQL As Understood By SQLite" for more information about date functions.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .