Re: [BUGS] Postgres storing time in strange manner

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: [BUGS] Postgres storing time in strange manner
Дата
Msg-id 1032099066.19130.4.camel@jester
обсуждение исходный текст
Ответ на Postgres storing time in strange manner  (Casey Allen Shobe <cshobe@secureworks.net>)
Список pgsql-novice
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.

--
  Rod Taylor


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

Предыдущее
От: "James F. Martin"
Дата:
Сообщение: WAL file size too big
Следующее
От: Hubert depesz Lubaczewski
Дата:
Сообщение: Re: pl/pgsql and returns timestamp type