Retrieve message history from Viber PC version Announcing the arrival of Valued Associate...

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



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Retrieve an html page from history?Retrieve/Export contacts from Viber PC versionChange viber for windows downdload location fromWill it work : Deactivate Viber to delete message?PC Viber Notification Not Going AwayViber desktop through proxyRetrieve Contacts from Viber PCDisable ads in ViberViber desktop microphone behaving oddlyHow to close Viber on a laptop without uninstalling?





.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










share|improve this question














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.






















    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










    share|improve this question














    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.


















      0












      0








      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










      share|improve this question














      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













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 17 '16 at 12:57









      simplysimply

      611




      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.







      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.
























          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


























            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


















            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









            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






























              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




























                0












                0








                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















                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














                share|improve this answer



                share|improve this answer








                edited Apr 24 '16 at 16:55









                techraf

                4,127111731




                4,127111731










                answered Apr 20 '16 at 9:48









                Fabrice PLATELFabrice PLATEL

                1




                1






























                    draft saved

                    draft discarded




















































                    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.




                    draft saved


                    draft discarded














                    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





















































                    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







                    Popular posts from this blog

                    VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

                    Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

                    Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...