On Mon, Mar 16, 2009 at 9:00 AM, MikeW <mw_p...@yahoo.co.uk> wrote: > Timothy A. Sawyer <tsaw...@...> writes: > >> >> I stand corrected on the math >> >> Bottom line is that different applications use different baseline values for > epoch (beginning of time) >> and you must know that baseline value >> ------Original Message------ >> From: Kees Nuyt >> Sender: sqlite-users-boun...@... >> To: sqlite-us...@... >> ReplyTo: sqlite-us...@... >> Sent: Mar 13, 2009 14:58 >> Subject: Re: [sqlite] datetime as integer >> >> Just a few corrections. >> > SNIP >> For date calculations, SQLite prefers real values containing >> number of days since noon in Greenwich on November 24, 4714 >> B.C., using the Proleptic Gregorian calendar: > SNIP > > "noon in Greenwich on November 24, 4714 BC" - > presumably that's the beginning of time for Creationists ... > > MikeW > ;-) >
guess it is better than using the apoplectic calendar. -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from: Madison WI United States. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
