Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year
Дата
Msg-id 20141107070257.GA29045@momjian.us
обсуждение исходный текст
Ответ на Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year  (Bruce Hunsaker <hunsakerbn@ldschurch.org>)
Ответы Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year  (Bruce Hunsaker <hunsakerbn@ldschurch.org>)
Список pgsql-bugs
On Thu, Nov  6, 2014 at 07:29:49AM -0700, Bruce Hunsaker wrote:
> > I have applied the attached C comment to document why we use the
> > Gregorian calendar for pre-1582 years.
>
> Thanks everyone for the response. I guess the bottom line for us
> is that if we want to store dates before 1582, we may not want
> to use date or timestamp columns for that data, particularly if
> the dates are from a Julian calendar.

Yeah, the big problem is that there is no way to store leap days for
years like 1500.  The only good part is that the Gregorian calendar is
very good at keeping the calendar aligned with the seasons.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Invalid page in block on autovacuum
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] ltree::text not immutable?