Re: Imprecision of DAYS_PER_MONTH

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Imprecision of DAYS_PER_MONTH
Date: 2005-07-22 19:37:38
Message-ID: slrnde2io2.2k2r.andrew+nonews@trinity.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2005-07-22, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
> Bruno Wolff III wrote:
>> According to the current calendar (again ignoring leap seconds) there
>> are exactly 365.2425 days per year on average. I think it makes sense to use
>> this number when dealing with calendar years and months.
>
> Someone came up with 365.2422. Which is better?

That's the difference between the tropical year (time between equinoxes)
and the calendar year. It will take about 3500 years for that to cause an
error of 1 day in the calendar (which has lead to some suggestions that
the year 4000 should not be a leap year) but in practice other errors are
likely to be more important by then.

The calendar year of the Gregorian calendar is 365.2425 days.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2005-07-22 19:42:01 Re: Imprecision of DAYS_PER_MONTH
Previous Message Dann Corbit 2005-07-22 19:27:50 Re: Imprecision of DAYS_PER_MONTH