MikeW 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 ... >
That would be October 23, 4004 BCE (according the the Bishop of Ussher). Noon, IIRC. I would assume using Radiometric dating as a starting point would be a tad unwieldy for day to day usage. http://en.wikipedia.org/wiki/Dating_Creation John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users