One nice thing about the string representation is that you can read it. This is VERY useful for debugging. In theory SQLite will allow different representations to interoperate seamlessly, but it's not something I would want to rely on.
So, you pays your money and you takes your choice. On Dec 27, 12:29 pm, Kristopher Micinski <krismicin...@gmail.com> wrote: > Yes, > > This is why I included a link to the original SQLite reference in the > links I previously provided :-). > > I agree with the long / string representation, but it's all just > representation, each has its advantages / disadvantages, though for > sorting and selection, this might be nice. I'm not an advanced SQL > user, but maybe a string format would provide some niceties with > respect to selection as well, however you could probably do the same > thing easily enough by working with some date / long conversions in > java then selecting in SQL. > > kris > > On Mon, Dec 27, 2010 at 9:07 AM, DanH <danhi...@ieee.org> wrote: > > It should be pointed out that long integer is one of the date formats > > supported by SQLite. > > > On Dec 27, 1:39 am, Kostya Vasilyev <kmans...@gmail.com> wrote: > >> Kris & Pramod, > > >> With all due respect, there is a much easier way. > > >> Java date/time stamps are internally represented by "long" values, the > >> value being the number of milliseconds since Jan. 1, 1970 GMT. > > >> SQLite natively supports long (64-bit) interger values (use INTEGER data > >> type). > > >> So, for storing date/time stamp, call "long milliseconds = > >> Date.getTime()" and store the long integer value in the database. > > >> When retrieving, get the long integer from the database, then construct > >> "new Date(long milliseconds)". > > >> This has two advantages: > > >> - No text parsing or formatting necessary, smaller chance of bugs > > >> - Ability to sort or select before / after a certain date/time value > >> when doing SELECT > > >> Hope this helps. > >> -- Kostya > > >> 27.12.2010 10:06, Kristopher Micinski пишет: > > >> >http://sberka.blogspot.com/2009/07/date-time-sqlite-and-android.html > > >> > That blog post should point you in the right direction. > > >> > What you may really want to know is how SQLite handles date and time. > >> > > From what I've encountered there is no "native" date/time handling in > >> > SQLite, but you can simply store dates / times in a textual > >> > representation. The following articles may help give some insight: > > >> >http://stackoverflow.com/questions/4248064/delphi-sqlite-date-time-fo... > > >> >http://www.sqlite.org/lang_datefunc.html > > >> > Typically what you will do is create some database implemented via a > >> > content provider or just database handler (see the many, many > >> > tutorials on how to do this) and create a table for storing your > >> > relevant information. For example, I have a "contents" table, where > >> > one of the columns is the date an article was published. Now the only > >> > thing you have to figure out is the marshaling. > > >> > Thanks, > >> > Kris Micinski > > >> > On Mon, Dec 27, 2010 at 1: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 > > >> -- > >> Kostya Vasilyev -- WiFi Manager + pretty widget > >> --http://kmansoft.wordpress.com > > > -- > > 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
