Re: Imprecision of DAYS_PER_MONTH - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Imprecision of DAYS_PER_MONTH
Date
Msg-id 200507212034.j6LKYUM15785@candle.pha.pa.us
Whole thread Raw
In response to Re: Imprecision of DAYS_PER_MONTH  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark wrote:
> 
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 
> > > > BTW, if you actually wanted to improve readability, defining a
> > > > SECS_PER_YEAR value and replacing the various occurrences of
> > > > "36525 * 864" with it would help.
> > > > 
> > > IIRC the number of seconds in a year is far from a constant.
> > 
> > Yes, I added a comment mentioning that we don't track leap seconds.
> > And this doesn't handle crossing uneven daylight savings time intervals.
> 
> It doesn't even represent leap years, never mind leap seconds.

Good, point, mention added.

--  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: [PATCHES] Roles - SET ROLE Updated
Next
From: "Dann Corbit"
Date:
Subject: Re: Imprecision of DAYS_PER_MONTH