Hello all, I'm a bit confused as to how to handle different timezones when saving datetimes to the local database in Android.
When I do a SELECT DateTime('now') in the sqlite3 database created by Android, it says "2010-08-09 03:07:19" but my current time is actually "2010-08-08 23:07:19" (eg: 4 hours earlier). Why is that? Does that mean I need to add 4 hours to all datetimes so they match the sqlite3 timezone? For example: How would I go about converting a string like "8-8-2010 11:00 AM EST" into the proper format for sqlite3? Bara -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en