+1 to what harri said, store stuff as time since the epoch or something, and then you can select using standard SQL filters..
kris On Mon, Sep 10, 2012 at 2:07 AM, Sadhna Upadhyay <sadhna.braah...@gmail.com> wrote: > Hi everybody, > i want to know that how to convert,let me first explain application( > i have created database and taken date from date picker and converted it > into string then passed to sq-lite database class) and now i want retrieve > data between specified range like (1 July 2012 to 30 July 2012 ),but the > problem is this that i have store date as a string format,pls guys help me > if any one of you have any idea about it. > > > > > Thanks: > sadhana > > -- > 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 -- 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