Re: '1 year' = '360 days' ????

From: Guy Fraser <guy(at)incentre(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: '1 year' = '360 days' ????
Date: 2004-10-27 22:40:32
Message-ID: 418023E0.7050900@incentre.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

>Bruno Wolff III <bruno(at)wolff(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-27 22:44:29 Re: Question Regarding Locks
Previous Message Alvaro Herrera 2004-10-27 22:39:05 Re: interval to seconds conversion. How?