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 по дате отправления: