Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   MySQL (https://www.askmehelpdesk.com/forumdisplay.php?f=442)
-   -   Convert Kik Messenger timestamps from SQL db (https://www.askmehelpdesk.com/showthread.php?t=720318)

  • Dec 2, 2012, 12:10 PM
    mnicholas81
    Convert Kik Messenger timestamps from SQL db
    I am looking at the SQL from my Kik Messenger database and the timestamps seem to be relative (and negative). How do I convert them to human date + time?

    For example:

    Message ID 5887 timestamp = -862616796
    Message ID 5888 timestamp = -862580966
    Message ID 5889 timestamp = -862572580

    • All times are GMT -7. The time now is 11:08 PM.