Re: [android-developers] how to retrieve data between specified date
+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 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
Re: [android-developers] how to retrieve data between specified date
Hi, It may be best if you didn't store dates as Strings for this use case - if never to be more precise. Firstly, using Strings you hardcode application language. Secondly, comparisons become next to impossible compared to e.g long comparisons. -- H On Sep 10, 2012 9:07 AM, "Sadhna Upadhyay" 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
[android-developers] how to retrieve data between specified date
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