Re: '1 year' = '360 days' ???? - Mailing list pgsql-general

From Guy Fraser
Subject Re: '1 year' = '360 days' ????
Date
Msg-id 418023E0.7050900@incentre.net
Whole thread Raw
In response to Re: '1 year' = '360 days' ????  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

>Bruno Wolff III <bruno@wolff.to> writes:
>
>
>>Wikipedia gives 365.242189670 days (86400 seconds) as the length of
>>the mean solar year in 2000. To give you some idea of how constant
>>that values is, Wikipedia claims that 2000 years ago the mean solar
>>year was about 10 seconds longer.  Using the above value I get there
>>is an average of 2629743 seconds in a month.
>>
>>
>>And yet another option is to note that in the Gregorian calendar there are
>>400*365+97 days or 400*12 months in 400 years, which gives 2629746 seconds
>>per month on average.
>>
>>
>
>I like the latter approach, mainly because it gives a defensible
>rationale for using a particular exact value.  With the solar-year
>approach there's no strong reason why you should use 2000 (or any other
>particular year) as the reference; and any value you did use would be
>subject to both roundoff and observational error.  With the Gregorian
>calendar as reference, 2629746 seconds is the *exact* answer, and it's
>correct because the Pope says so ;-).
>
>(Or, for the Protestants among us, it's correct because the SQL standard
>specifies use of the Gregorian calendar.)
>
>            regards, tom lane
>
>
Give or take one day every 4000 years. ;-)

--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787

There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.




pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: interval to seconds conversion. How?
Next
From: Tom Lane
Date:
Subject: Re: Question Regarding Locks