Re: Imprecision of DAYS_PER_MONTH - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Imprecision of DAYS_PER_MONTH
Date
Msg-id 200507221903.j6MJ3Dc13936@candle.pha.pa.us
Whole thread Raw
In response to Re: Imprecision of DAYS_PER_MONTH  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-hackers
Bruno Wolff III wrote:
> On Thu, Jul 21, 2005 at 13:47:29 -0700,
>   Dann Corbit <DCorbit@connx.com> wrote:
> > In round figures:
> > 
> > Since there are 365.2422 days per tropical year, there are 31556926
> > seconds per year (give or take leap seconds).
> > 
> > Ref:
> > http://www.grc.nasa.gov/WWW/K-12/Numbers/Math/Mathematical_Thinking/cale
> > ndar_calculations.htm
> 
> 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?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] Planner doesn't look at LIMIT?
Next
From: Bruce Momjian
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC