Re: Postgres storing time in strange manner

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Postgres storing time in strange manner
Дата
Msg-id 1032101495.19130.29.camel@jester
обсуждение исходный текст
Ответ на Re: Postgres storing time in strange manner  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Sun, 2002-09-15 at 10:32, Tom Lane wrote:
> > On Sunday 15 September 2002 10:11 am, Rod Taylor wrote:
> >> On Sun, 2002-09-15 at 03:57, Casey Allen Shobe wrote:
> >>> I don't have a clue why it's doing this - has anyone else seen this sort
> >>> of behavior, or know why it might be doing it?  It shows times wrong, for
> >>> instance, it shows 00:04:60 where it should show 00:05:00.  See below:
> >>
> >> There are actually 61 seconds in some minutes.  In order to accommodate
> >> leap seconds, PostgreSQL allows this to happen -- similarly to how it
> >> will also allow 366 days in some years.
>
> True but irrelevant -- PG does not do accounting for leap seconds.

For some reason I thought it did accommodate it when I was still using
7.1.

Ahh well, if the bug is fixed, then it's all good.

--
  Rod Taylor


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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Postgres storing time in strange manner
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #768: Wrong special characters handling in Java