Hi Jonathon, You may already be aware of this, but I didn't see it here in the discussion so I thought I'd chime in. SQLite doesn't really provide a native datetime type. The data type documentation lays out what's going on in detail (link below), but I'm pretty certain that your datetime column is actually a TEXT type.
http://sqlite.org/datatype3.html If this poses an efficiency problem, others have suggested some good work-arounds earlier. I suspect that for the general use-cases of SQLite, storing date-time information in this way isn't really going have too bad of an impact. And, as others have pointed out, you'll almost always have to do some kind of mapping in your application from how the db stores date-times to how your platform likes to do it (i.e. NSDate), and then you'll be manipulating those objects at presentation time for the end-user. So I would just rock it and not worry about it too much. If you're really that hard up on saving CPU cycles, they might be better gained elsewhere. Cheers, Billy On Sat, Feb 28, 2009 at 8:30 PM, jonwood <nab...@softcircuits.com> wrote: > > > John Stanton-3 wrote: > > > > Use the Sqlite date storage format and support. With that approach > > which is astronomivally correct you can deliver any date format or > > manipulwtion, You may need some custom written functions. to get week > > number according to national rules etc, but the method is sound. It is > > also compatible with different date systems. > > > > Thanks, but I'm not sure what this means. "SQLite date storage format and > support" doesn't appear to be a specific term (at least, it didn't turn up > anything specific on Google). Is there a link that would describe what > you're referring to and how it'd help my situation? > > Thanks. > > Jonathan > > > -- > View this message in context: > http://www.nabble.com/DateTime-Objects-tp22264879p22268988.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Billy Gray wg...@zetetic.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
