+ Reply
Results 1 to 3 of 3

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: Edit SMS Receive Time

is a discussion within the

General iPhone Chat

forums, a part of the

iPhone Modding

section;
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
...
  1. #1
    iPhone? More like MyPhone
    Join Date
    Aug 2007
    Posts
    272
    Thanks
    15
    Thanked 14 Times in 14 Posts

    Default Edit SMS Receive Time
    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.

  2. #2
    iPhone? More like MyPhone The Punisher's Avatar
    Join Date
    Nov 2007
    Posts
    116
    Thanks
    5
    Thanked 13 Times in 10 Posts

    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.

  3. The Following User Says Thank You to The Punisher For This Useful Post:

    pmas (12-01-2007)

  4. #3
    iPhone? More like MyPhone
    Join Date
    Aug 2007
    Posts
    272
    Thanks
    15
    Thanked 14 Times in 14 Posts

    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; 12-01-2007 at 05:43 AM.

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts