Re: Imprecision of DAYS_PER_MONTH - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Imprecision of DAYS_PER_MONTH
Date
Msg-id 87ek9sc4uj.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Imprecision of DAYS_PER_MONTH  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Imprecision of DAYS_PER_MONTH
List pgsql-hackers
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.

-- 
greg



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [PATCHES] Roles - SET ROLE Updated
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Roles - SET ROLE Updated