1. pmas's Avatar
    Hi all.
    Has anyone deciphered the time/date of an SMS message when viewed in SQLite? The date shows cryptic numbers like 11675543 instead of Nov 29 7AM etc. I have forwarded messages that I would like to make accurate by changing this field. Any input appreciated.
    2007-11-29 02:04 PM
  2. The Punisher's Avatar
    i assume that the timestamp is in linux hence why you see it like that.

    ie: The timestamp 1196365522 corresponds to
    2007/11/29 11:45:22 am PST.
    2007-11-29 05:05 PM
  3. pmas's Avatar
    Thanks. I just found a website that converts the string into the time. But I need to convert the date/time into a unix string. Any idea?
    Last edited by pmas; 2007-12-01 at 02:43 PM.
    2007-12-01 02:37 PM