Retrieve message history from Viber PC version
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
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
asked Mar 17 '16 at 12:57
simply
611
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
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
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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,975111729
answered Apr 20 '16 at 9:48
Fabrice 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
});
}
});
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
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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,975111729
answered Apr 20 '16 at 9:48
Fabrice 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.
edited Apr 24 '16 at 16:55
techraf
3,975111729
answered Apr 20 '16 at 9:48
Fabrice 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.
edited Apr 24 '16 at 16:55
techraf
3,975111729
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,975111729
answered Apr 20 '16 at 9:48
Fabrice PLATEL
1
edited Apr 24 '16 at 16:55
techraf
3,975111729
edited Apr 24 '16 at 16:55
techraf
3,975111729
edited Apr 24 '16 at 16:55
techraf
3,975111729
3,975111729
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 |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
