"jonwood" <nab...@softcircuits.com> wrote in message news:22264879.p...@talk.nabble.com > I have a SQLite table that contains a DATETIME value. However, the > database does not appear to provide enough control over how that > value is formatted. For example, I'd like a two-digit year, to > eliminate leading zeros, and to show time using AM/PM format.
Database is for manipulating data. Your UI application is for presenting it nicely to the user. After all, you don't complain that SQLite, say, doesn't have functions for formatting numbers in user-friendly manner (e.g. 123,456.78). > Is the ONLY way to accomplish this to manually parse the database > value into separate values and then work with that? Is there no way > to access these values in binary format without the overhead of > convert to text and then back again? You can store dates as doubles representing Julian dates, or as integers representing number of seconds since Unix epoch (aka time_t). Is this the kind of bindary format you are talking about? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
