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 So 31557600 seems to be off by quite a bit. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Bruce Momjian > Sent: Thursday, July 21, 2005 1:35 PM > To: Greg Stark > Cc: Tino Wildenhain; Tom Lane; PostgreSQL-development; Marc G. Fournier > Subject: Re: [HACKERS] Imprecision of DAYS_PER_MONTH > > 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, Pennsylvania > 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
