Retrieve message history from Viber PC version
up vote
0
down vote
favorite
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
window history viber
asked Mar 17 '16 at 12:57
simply
611
bumped to the homepage by Community♦ 2 days ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
up vote
0
down vote
favorite
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
window history viber
asked Mar 17 '16 at 12:57
simply
611
bumped to the homepage by Community♦ 2 days ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
window history viber
asked Mar 17 '16 at 12:57
simply
611
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
window history viber
window history viber
asked Mar 17 '16 at 12:57
simply
611
asked Mar 17 '16 at 12:57
simply
611
asked Mar 17 '16 at 12:57
simply
611
asked Mar 17 '16 at 12:57
simply
611
asked Mar 17 '16 at 12:57
simply
611
611
bumped to the homepage by Community♦ 2 days ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 2 days ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
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.
edited Apr 24 '16 at 16:55
techraf
3,957111729
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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.
edited Apr 24 '16 at 16:55
techraf
3,957111729
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
add a comment |
up vote
0
down vote
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.
edited Apr 24 '16 at 16:55
techraf
3,957111729
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
add a comment |
up vote
0
down vote
up vote
0
down vote
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.
edited Apr 24 '16 at 16:55
techraf
3,957111729
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
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.
edited Apr 24 '16 at 16:55
techraf
3,957111729
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
edited Apr 24 '16 at 16:55
techraf
3,957111729
edited Apr 24 '16 at 16:55
techraf
3,957111729
edited Apr 24 '16 at 16:55
techraf
3,957111729
3,957111729
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
1
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1054028%2fretrieve-message-history-from-viber-pc-version%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
