On Sat, 28 Feb 2009 12:27:10 -0800 (PST), jonwood <nab...@softcircuits.com> wrote:
>Derrell Lipman wrote: >> >> http://sqlite.org/lang_datefunc.html >> > >Exactly. No 2-digit year format, no AM/PM format, and no way to eliminate >leading zeros, etc. Just as I pointed out in my original post. Well, I would say you (or your users) live in the past. The rest of the world uses ISO-8601 ;) http://www.cl.cam.ac.uk/~mgk25/iso-time.html Pun aside, you can always deliver epoch (or something else you find more convenient) to your application and let the application do the formatting. SQL isn't meant for presentation anyway, it's for relational storage. Example: Compute the time since the unix epoch in seconds (like strftime('%s','now') except this includes the fractional part): SELECT (julianday('now') - 2440587.5)*86400.0; HTH -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
