On Wednesday, January 31, 2007 Rick van der Lans wrote:
> The manual states that the function julianday returns the number of days
> since noon in Greenwich on November 24, 4714 B.C. That would imply that the
> statement:
> Select julianday('-4714-11-24 12:00:00');
> Should return 0.0. But it doesn't, it returns -365.0
> Does this mean, that the manual should say "since noon in Greenwich on
> November 24, 4713 B.C.? Or am I missing something?
sqlite> Select julianday('-0001-11-24 12:00:00');
1721022.0
sqlite> Select julianday('0000-11-24 12:00:00');
1721388.0
sqlite> Select julianday('0001-11-24 12:00:00');
1721753.0
There is no year 0. The calendar goes from -1 BCE to 1 CE. 0000-11-24
is 1 BCE. So, if you want November 24, 4714 B.C. you need to say
sqlite> Select julianday('-4713-11-24 12:00:00');
0.0
e
--
Doug Currie
Londonderry, NH, USA
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
