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

Reply via email to