Store it any way you want. If you want to do selection by date I'd favor long integer (seconds since 1970), unless you need sub-second resolution. But supposedly SQLite can sort out (and select by) a wide variety of date formats, as described in the article someone referenced.
On Dec 27, 12:21 am, "pramod.deore" <deore.pramo...@gmail.com> wrote: > Hi everyone, > In my application I have 2 buttons one for DatePickerand > one for Timepicker. Date piker gives me date in this format - > 12-27-2010 and time in - 11:48. Now I want to create table to store > these values. How to store date and time in android database? > Thanks. -- 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