On Sat, 28 Feb 2009 17:30:24 -0800 (PST), jonwood <nab...@softcircuits.com> wrote:
>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). I'm almost sure John Stanton had this in mind: The number of days since noon in Greenwich on November 24, 4714 B.C. , as described in the return value of julianday(). http://www.sqlite.org/lang_datefunc.html http://en.wikipedia.org/wiki/Proleptic_Gregorian_calendar Then, use the SQLite datetime functions to return any of a few supported formats your application can cope with. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
