RE: [sqlite] Does julianday work according to the manual?
Thanks for your help, guys,
It now makes sense.
Rick van der Lans
-Oorspronkelijk bericht-
Van: Doug Currie [mailto:[EMAIL PROTECTED]
Verzonden: Wednesday, January 31, 2007 4:16 PM
Aan: sqlite-users@sqlite.org
Onderwerp: Re: [sqlite] Does julianday work according to the manual?
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('-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. -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]
-
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Re: [sqlite] Does julianday work according to the manual?
"info" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> 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?
>
The year -4713 and 4714 b.c. are the same year. When using
historical notation (eg: "b.c.") you skip the zero year and go
straight from 1 a.d. to 1 b.c. When using astronomical notation
(eg: -4713) there is a 0 year, which corresponds to 1 b.c.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Re: [sqlite] Does julianday work according to the manual?
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('-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. -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]
-
Re: [sqlite] Does julianday work according to the manual?
Wikipedia also disagrees with the 24. Nov of 4714 B.C. as start of julian days... http://en.wikipedia.org/wiki/Julian_day (Footnote from that page..) ^ This equals November 24, 4714 BC in the proleptic Gregorian calendar. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Does julianday work according to the manual?
info schrieb:
Hi,
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?
Wikipedia also disagrees with the 24. Nov of 4714 B.C. as start of
julian days...
http://en.wikipedia.org/wiki/Julian_day
Michael
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[sqlite] Does julianday work according to the manual?
Hi,
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?
Rick van der Lans
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
