Tjyylli

If Windows 7 doesn't support WSL, then what is "Subsystem for UNIX-based Applications"?

What does 丫 mean? 丫是什么意思？

Central Vacuuming: Is it worth it, and how does it compare to normal vacuuming?

What does Turing mean by this statement?

Random body shuffle every night—can we still function?

Why is the change of basis formula counter-intuitive? [See details]

How can I prevent/balance waiting and turtling as a response to cooldown mechanics

Getting out of while loop on console

A term for a woman complaining about things/begging in a cute/childish way

"klopfte jemand" or "jemand klopfte"?

How to change the tick of the color bar legend to black

How can a team of shapeshifters communicate?

The test team as an enemy of development? And how can this be avoided?

Is multiple magic items in one inherently imbalanced?

Did pre-Columbian Americans know the spherical shape of the Earth?

The Nth Gryphon Number

Resize vertical bars (absolute-value symbols)

Why is a lens darker than other ones when applying the same settings?

Why shouldn't this prove the Prime Number Theorem?

Why is it faster to reheat something than it is to cook it?

Delete free apps from library

Did Mueller's report provide an evidentiary basis for the claim of Russian govt election interference via social media?

New Order #6: Easter Egg

After Sam didn't return home in the end, were he and Al still friends?

Retrieve message history from Viber PC version

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

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

window history viber

share|improve this question

asked Mar 17 '16 at 12:57

simplysimply

611

bumped to the homepage by Community♦ 6 hours 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 | 

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

window history viber

share|improve this question

asked Mar 17 '16 at 12:57

simplysimply

611

bumped to the homepage by Community♦ 6 hours 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 | 

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

share|improve this question

asked Mar 17 '16 at 12:57

simplysimply

611

share|improve this question

asked Mar 17 '16 at 12:57

simplysimply

611

share|improve this question

asked Mar 17 '16 at 12:57

simplysimply

611

asked Mar 17 '16 at 12:57

simplysimply

611

asked Mar 17 '16 at 12:57

simplysimply

611

1 Answer
1

active

oldest

votes

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.

share|improve this answer

edited Apr 24 '16 at 16:55

techraf

4,127111731

answered Apr 20 '16 at 9:48

Fabrice PLATELFabrice PLATEL

1

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

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.

share|improve this answer

edited Apr 24 '16 at 16:55

techraf

4,127111731

answered Apr 20 '16 at 9:48

Fabrice PLATELFabrice PLATEL

1

add a comment | 

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.

share|improve this answer

edited Apr 24 '16 at 16:55

techraf

4,127111731

answered Apr 20 '16 at 9:48

Fabrice PLATELFabrice PLATEL

1

add a comment | 

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.

share|improve this answer

edited Apr 24 '16 at 16:55

techraf

4,127111731

answered Apr 20 '16 at 9:48

Fabrice PLATELFabrice PLATEL

1

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

share|improve this answer

edited Apr 24 '16 at 16:55

techraf

4,127111731

answered Apr 20 '16 at 9:48

Fabrice PLATELFabrice PLATEL

1

edited Apr 24 '16 at 16:55

techraf

4,127111731

edited Apr 24 '16 at 16:55

techraf

4,127111731

answered Apr 20 '16 at 9:48

Fabrice PLATELFabrice PLATEL

1

answered Apr 20 '16 at 9:48

Fabrice PLATELFabrice PLATEL

1