SMS time stamps are behaving strangely I am having an issue with the time stamps of incoming SMS messages when backing up messages. The time stamps of the messages I send out are correct. The time stamps of the incoming messages in the backup files are 8 hours before the correct time. I read elsewhere that this can happen when you are roaming. I have a Motorola XPRT on Sprint and I live in California.

I downloaded and used about 5 different SMS backup applications (both free and paid) to try to archive my messages. They all have this problem.

Now here's the interesting part. The time stamps rendered in the stock SMS application are correct. I tried 2 third-party SMS applications with different results. Handcent SMS shows the time stamps correctly. Go SMS Pro show the incoming messages with the same incorrect time stamps as the backup files.

This leads me to a point of reevaluation. The database that stores the messages on the phone is storing multiple time stamps. I'm guessing they have sent time (the time that is 8 hours behind what it should be) and received time fields. The backup applications and Go SMS Pro are probably using the sent times. The default SMS application and Handcent SMS are probably using the received times.

Ok so now I need a way to solve this issue. To do that I need answers to some questions:


Does Android use SQLite to store SMS messages?
Where is the SMS database is located?
How and where are MMS messages stored?
How can I copy the database to my computer?
Do I have to root my phone? How do I do that? Does doing this affect my warranty with Sprint?


UPDATE:

It looks this is a known problem where the time zone offset is applied 2 times instead of 1. There is a ticket for it here http://code.google.com/p/android/issues/detail?id=1305. This ticket is more than 3 years old and is still open.
What timezone are you in? It sounds like when you back them up, it is saving them in a different Timezone (maybe UTC). 

to answer your other questions:


Yes, SQLite is used for the messages
/data/data/com.android.providers.telephony/databases/mmssms.db
Same way as SMS messages : /data/data/com.android.providers.telephony/databases/mmssms.db
You can use ADB from the android SDK and copy it to your PC by doing:
c:/android-sdk/tools/&gt; adb pull /data/data/com.android.providers.telephony/databases/mmssms.db c:/users/my-account/desktop/mmssms.db
Yes, you will have to root your phone to get access to that directory.


maybe check out SMS Backup + in the android market. It will backup your sms messages (doesn't do MMS yet) to your GMail account and put them in an SMS label. It will also restore them too.