Re: Imprecision of DAYS_PER_MONTH
| От | Bruno Wolff III |
|---|---|
| Тема | Re: Imprecision of DAYS_PER_MONTH |
| Дата | |
| Msg-id | 20050721140934.GB21293@wolff.to обсуждение исходный текст |
| Ответ на | Imprecision of DAYS_PER_MONTH (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Ответы |
Re: Imprecision of DAYS_PER_MONTH
Re: Imprecision of DAYS_PER_MONTH Re: Imprecision of DAYS_PER_MONTH |
| Список | pgsql-hackers |
On Thu, Jul 21, 2005 at 09:39:38 -0400, Bruce Momjian <pgman@candle.pha.pa.us> wrote: > > I have added this comment above the DAYS_PER_MONTH macro: > > + /* > + * DAYS_PER_MONTH is very imprecise. The more accurate value is > + * 365.25/12 = 30.4375, or '30 days 10:30:00'. Right now we only > + * return an integral number of days, but someday perhaps we should > + * also return a 'time' value to be used as well. > + */ > #define DAYS_PER_MONTH 30 /* assumes exactly 30 days per month */ > > Let me add that we could actually do this in many places now because we > are already converting to 'time' in those places. Is this a TODO? Shouldn't you be using 365.2425/12 (30.436875) for the number of days per month?
В списке pgsql-hackers по дате отправления: